# View: dev_hsingh_upc_to_contract

**View Name:** dev_hsingh_upc_to_contract
**Table Source:** `ROYALTY_ACCOUNTING.QA.VW_UPC_TO_CONTRACT_MAPPING`
**File Path:** `views/dev_hsingh_upc_to_contract.view.lkml`

## Overview

- **File Size:** 2335 bytes
- **Lines of Code:** 92
- **Dimensions:** 10
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 1

## Comments & Notes

- dimension: display_upc {
- type: number
- sql:case when ${TABLE}.display_upc = '' then null else ${TABLE}.display_upc end;;

## Dimensions

| Name | Type |
|------|------|
| `digital_old_upc` | string |
| `physical_old_upc` | string |
| `account_id` | number |
| `contract_id` | number |
| `term_type` | string |
| `term_rate` | string |
| `orchard_upc` | number |
| `MANUFACTURER_UPC` | number |
| `run_controller_id` | number |
| `display_upc` | number |

## Filters

- `upc_search_value`

## Derived Table

```sql
sql:
    select * from (
      with stmt_db_prod_remaps AS (select * from STMT_DB.PROD.REMAPS where (territory is null or territory = '') and active = 'Y'),
      stmt_db_physical_remaps AS (select * from STMT_DB.PROD.REMAPS_PHYSICAL where active = 'Y')
      select
        orchard_upc,
        display_upc,
        manufacturer_upc,
        account_id,
        contract_id,
        term_type,
        term_rate,
        run_controller_id,
        r.old_upc as digital_old_upc,
        rp.old_upc as physical_old_upc
      from
        royalty_accounting.qa.vw_upc_to_contract_mapping ucm
        left join stmt_db_prod_remaps r on ucm.display_upc = r.new_upc
        left join stmt_db_physical_remaps rp on rp.new_upc = ucm.display_upc
        where display_upc not in (select old_upc from stmt_db_prod_remaps)
   and display_upc not in (select old_upc from STMT_DB.PROD.REMAPS_PHYSICAL))
  where  {% condition upc_search_value %
```