# View: all_rights_blocks

**View Name:** all_rights_blocks
**Table Source:** `Derived from: Awal_Sax, Awal_Sax.Sax`
**File Path:** `views/all_rights_blocks.view.lkml`

## Overview

- **File Size:** 5089 bytes
- **Lines of Code:** 177
- **Dimensions:** 25
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `AGR_ID` | string |
| `ASSIGNOR_ID` | string |
| `ASSIGNOR_NAME` | string |
| `ACQUIRER_NAME` | string |
| `AGR_DESCRIPTION` | string |
| `AGR_SIGNED_DATE` | date |
| `AGR_NOTES` | string |
| `AGR_IS_TERMINATED` | string |
| `STATEMENT_ON` | string |
| `RIGHTS_ID` | string |
| `USE_COP` | string |
| `USE_COT` | string |
| `RIGHTS_DESCRIPTION` | string |
| `RIGHT_TERRITORIES` | string |
| `COT_START_DATE` | date |
| `COT_END_DATE` | date |
| `DATES_ID` | string |
| `DATES_DESCRIPTION` | string |
| `IS_ACTIVE` | string |
| `PAY_PER_START` | date |
| `PAY_PER_END` | date |
| `ROY_PER_START` | date |
| `ROY_PER_END` | date |
| `AT_SOURCE` | string |
| `COMMISSION` | number |

## Derived Table

```sql
sql:
      SELECT
      RIGHTS.AGREEMENT_ID AGR_ID
    , ASSIGNORS.ID ASSIGNOR_ID
     , ASSIGNORS.NAME ASSIGNOR_NAME
     , ACQUIRERS.NAME ACQUIRER_NAME
     , AGREEMENTS.DESCRIPTION_OF_RIGHTS AGR_DESCRIPTION
     , AGREEMENTS.AGREEMENT_SIGNED_DATE AGR_SIGNED_DATE
     , AGREEMENTS.NOTES AGR_NOTES
     , AGREEMENTS.IS_TERMINATED AGR_IS_TERMINATED
     , AGREEMENTS.SHOULD_SEND_STATEMENT STATEMENT_ON
     , RIGHTS.ID RIGHTS_ID
     , RIGHTS.USE_FOR_CHAIN_OF_PAYMENT USE_COP
     , RIGHTS.USE_FOR_CHAIN_OF_TITLE USE_COT
     , RIGHTS.DESCRIPTION RIGHTS_DESCRIPTION
     , LISTAGG(TERRITORIES.NAME, '; ') WITHIN GROUP (ORDER BY REGEXP_COUNT(TERRITORIES.FULL_PATH, '/') - REGEXP_COUNT(TERRITORIES.FULL_PATH, 'TERR578')) RIGHT_TERRITORIES
     , TO_CHAR(RIGHTS.TITLE_START_DATE,'YYYY-MM-DD') COT_START_DATE
     , TO_CHAR(RIGHTS.TITLE_END_DATE,'YYYY-MM-DD') COT_END_DATE
     , RIGHT_DATES.ID DATES_ID
     , RIGHT_DATES.DESCRIPTION DATES_DESCRIPTION
     , RIGHT_DATES.ACTIVE_INACTIVE IS_ACTIVE
     , TO_CHAR(RIGHT_DATES.PAYMENT_PERIOD_START_DATE,'YYYY-MM-DD') PAY_PER_START
     , TO_CHAR(RIGHT_DATES.PAYMENT_PERIOD_END_DATE,'YYYY-MM-DD') PAY_PER_END
     , TO_CHAR(RIGHT_DATES.ROYALTY_PERIOD_START_DATE,'YYYY-MM-DD') ROY_PER_START
     , TO_CHAR(RIGHT_DATES.ROYALTY_PERIOD_END_DATE,'YYYY-MM-DD') ROY_PER_END
     , RIGHT_DATES.AT_SOURCE AT_SOURCE
     , RIGHT_DATES.COMMISSION_ON_RECEIVED_AMOUNT COMMISSION
     FROM awal_sax.sax.AGREEMENTS
     , awal_sax.sax.INTERESTED_PARTIES ASSIGNORS
     , awal_sax.sax.INTERESTED_PARTIES ACQUIRERS
     , awal_sax.sax.RIGHTS
     , awal_sax.sax.RIGHT_DATES
     , awal_sax.sax.TERRITORIES
     , awal_sax.sax.AGR_TERR_DEF_TERRS
     , awal_sax.sax.RIGHT_TERR_DEFS
     WHERE RIGHTS.AGREEMENT_ID = AGREEMENTS.ID
     AND AGREEMENTS.ASSIGNOR_ID = ASSIGNORS.ID
     AND AGREEMENTS.ACQUIRER_ID = ACQUIRERS.ID
     AND RIGHT_DATES.RIGHT_ID = RIGHTS.ID
     AND RIGHTS.ID = RIGHT_TERR_DEFS.RIGHT_ID
     AND RIGHT_TERR_DEFS.TERRITORY_DEFINITION_ID = AGR_TERR_DEF_TERRS.TERRITORY_DEFINITION_ID
     AND AGR_TERR_DEF_TERRS.TERRITORY_ID = TERRITORIES.ID
     AND AGREEMENTS.CLIENT_RIGHTS = 'Neighbouring Rights'
    group by RIGHTS.AGREEMENT_ID, ASSIGNORS.ID, ASSIGNORS.NAME, ACQUIRERS.NAME, AGREEMENTS.DESCRIPTION_OF_RIGHTS, AGREEMENTS.SHOULD_SEND_STATEMENT,
    AGREEMENTS.AGREEMENT_SIGNED_DATE, AGREEMENTS.NOTES, AGREEMENTS.IS_TERMINATED, RIGHTS.ID, RIGHTS.USE_FOR_CHAIN_OF_PAYMENT,
    RIGHTS.USE_FOR_CHAIN_OF_TITLE, RIGHTS.DESCRIPTION, TO_CHAR(RIGHTS.TITLE_START_DATE,'YYYY-MM-DD'), TO_CHAR(RIGHTS.TITLE_END_DATE,'YYYY-MM-DD'), RIGHT_DATES.ID,
    RIGHT_DATES.DESCRIPTION, RIGHT_DATES.ACTIVE_INACTIVE, TO_CHAR(RIGHT_DATES.PAYMENT_PERIOD_START_DATE,'YYYY-MM-DD'), TO_CHAR(RIGHT_DATES.PAYMENT_PERIOD_END_DATE,'YYYY-MM-DD'), TO_CHAR(RIGHT_DATES.ROYALTY_PERIOD_START_DATE,'YYYY-MM-DD'),
    TO_CHAR(RIGHT_DATES.ROYALTY_PERIOD_END_DATE,'YYYY-MM-DD'), RIGHT_DATES.AT_SOURCE, RIGHT_DATES.COMMISSION_ON_RECEIVED_AMOUNT;;
```