VIEW: APPS.MSC_SUP_DEM_HZ_UI_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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