Product: | MSC - Advanced Supply Chain Planning |
---|---|
Description: | |
Implementation/DBA Data: | APPS.MSC_SUP_DEM_HZ_UI_V |
SELECT PLAN_ID
, PUBLISHER_NAME
, PUBLISHER_SITE_NAME
, PUBLISHER_ORDER_TYPE
, PUBLISHER_ORDER_TYPE_DESC
, DECODE(SYS_CONTEXT('MSC'
, 'COMPANY_ID')
, PUBLISHER_ID
, PRIMARY_UOM
, CUSTOMER_ID
, TP_UOM_CODE
, SUPPLIER_ID
, TP_UOM_CODE
, UOM_CODE) UOM
, DECODE(SYS_CONTEXT('MSC'
, 'COMPANY_ID')
, PUBLISHER_ID
, PRIMARY_QUANTITY
, CUSTOMER_ID
, TP_QUANTITY
, SUPPLIER_ID
, TP_QUANTITY
, QUANTITY) QUANTITY
, KEY_DATE
, SUPPLIER_ID
, CUSTOMER_ID
, SUPPLIER_SITE_ID
, CUSTOMER_SITE_ID
, CUSTOMER_NAME
, SUPPLIER_NAME
, CUSTOMER_SITE_NAME
, SUPPLIER_SITE_NAME
, INVENTORY_ITEM_ID
, ITEM_NAME
, ITEM_NAME ITEM_DESCRIPTION
, OWNER_ITEM_NAME
, CUSTOMER_ITEM_NAME
, SUPPLIER_ITEM_NAME
, DECODE(SYS_CONTEXT('MSC'
, 'COMPANY_ID')
, CUSTOMER_ID
, CUSTOMER_NAME
, SUPPLIER_ID
, SUPPLIER_NAME
, PUBLISHER_NAME) MYCO
, DECODE(SYS_CONTEXT('MSC'
, 'COMPANY_ID')
, CUSTOMER_ID
, CUSTOMER_SITE_NAME
, SUPPLIER_ID
, SUPPLIER_SITE_NAME
, PUBLISHER_SITE_NAME) MYSITE
, DECODE(SYS_CONTEXT('MSC'
, 'COMPANY_ID')
, CUSTOMER_ID
, SUPPLIER_NAME
, SUPPLIER_ID
, CUSTOMER_NAME
, DECODE(PUBLISHER_ID
, CUSTOMER_ID
, SUPPLIER_NAME
, CUSTOMER_NAME)) TPCO
, DECODE(SYS_CONTEXT('MSC'
, 'COMPANY_ID')
, SUPPLIER_ID
, CUSTOMER_SITE_NAME
, CUSTOMER_ID
, SUPPLIER_SITE_NAME
, DECODE(PUBLISHER_ID
, CUSTOMER_ID
, SUPPLIER_SITE_NAME
, CUSTOMER_SITE_NAME)) TPSITE
, DECODE(SYS_CONTEXT('MSC'
, 'COMPANY_ID')
, SUPPLIER_ID
, 1
, CUSTOMER_ID
, 1
, 0) TP
FROM MSC_SUP_DEM_ENTRIES_UI_V