eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: MSC_CUST_BUCKET_V

Product:	MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data:	APPS.MSC_CUST_BUCKET_V

View Text

SELECT DECODE(PUBLISHER_ORDER_TYPE
, 1
, DECODE(SYS_CONTEXT('MSC'
, 'COMPANY_ID')
, PUBLISHER_ID
, PRIMARY_QUANTITY
, DECODE(PUBLISHER_ID
, CUSTOMER_ID
, SUPPLIER_ID
, CUSTOMER_ID)
, TP_QUANTITY
, QUANTITY)
, 0) AS SALES_FORECAST
, DECODE(PUBLISHER_ORDER_TYPE
, 2
, DECODE(SYS_CONTEXT('MSC'
, 'COMPANY_ID')
, PUBLISHER_ID
, PRIMARY_QUANTITY
, DECODE(PUBLISHER_ID
, CUSTOMER_ID
, SUPPLIER_ID
, CUSTOMER_ID)
, TP_QUANTITY
, QUANTITY)
, 0) AS ORDER_FORECAST
, DECODE(PUBLISHER_ORDER_TYPE
, 3
, DECODE(SYS_CONTEXT('MSC'
, 'COMPANY_ID')
, PUBLISHER_ID
, PRIMARY_QUANTITY
, DECODE(PUBLISHER_ID
, CUSTOMER_ID
, SUPPLIER_ID
, CUSTOMER_ID)
, TP_QUANTITY
, QUANTITY)
, 0) AS SUPPLY_COMMIT
, DECODE(PUBLISHER_ORDER_TYPE
, 4
, DECODE(SYS_CONTEXT('MSC'
, 'COMPANY_ID')
, PUBLISHER_ID
, PRIMARY_QUANTITY
, DECODE(PUBLISHER_ID
, CUSTOMER_ID
, SUPPLIER_ID
, CUSTOMER_ID)
, TP_QUANTITY
, QUANTITY)
, 0) AS HISTORICAL_SALES
, DECODE(PUBLISHER_ORDER_TYPE
, 5
, DECODE(SYS_CONTEXT('MSC'
, 'COMPANY_ID')
, PUBLISHER_ID
, PRIMARY_QUANTITY
, DECODE(PUBLISHER_ID
, CUSTOMER_ID
, SUPPLIER_ID
, CUSTOMER_ID)
, TP_QUANTITY
, QUANTITY)
, 0) AS SELL_THROUGH_FORECAST
, DECODE(PUBLISHER_ORDER_TYPE
, 6
, DECODE(SYS_CONTEXT('MSC'
, 'COMPANY_ID')
, PUBLISHER_ID
, PRIMARY_QUANTITY
, DECODE(PUBLISHER_ID
, CUSTOMER_ID
, SUPPLIER_ID
, CUSTOMER_ID)
, TP_QUANTITY
, QUANTITY)
, 0) AS NEGOTIATED_CAPACITY
, DECODE(PUBLISHER_ORDER_TYPE
, 7
, DECODE(SYS_CONTEXT('MSC'
, 'COMPANY_ID')
, PUBLISHER_ID
, PRIMARY_QUANTITY
, DECODE(PUBLISHER_ID
, CUSTOMER_ID
, SUPPLIER_ID
, CUSTOMER_ID)
, TP_QUANTITY
, QUANTITY)
, 0) AS SAFETY_STOCK
, DECODE(PUBLISHER_ORDER_TYPE
, 9
, DECODE(SYS_CONTEXT('MSC'
, 'COMPANY_ID')
, PUBLISHER_ID
, PRIMARY_QUANTITY
, DECODE(PUBLISHER_ID
, CUSTOMER_ID
, SUPPLIER_ID
, CUSTOMER_ID)
, TP_QUANTITY
, QUANTITY)
, 0) AS ALLOCATED_ONHAND
, DECODE(PUBLISHER_ORDER_TYPE
, 10
, DECODE(SYS_CONTEXT('MSC'
, 'COMPANY_ID')
, PUBLISHER_ID
, PRIMARY_QUANTITY
, DECODE(PUBLISHER_ID
, CUSTOMER_ID
, SUPPLIER_ID
, CUSTOMER_ID)
, TP_QUANTITY
, QUANTITY)
, 0) AS UNALLOCATED_ONHAND
, DECODE(PUBLISHER_ORDER_TYPE
, 13
, DECODE(SYS_CONTEXT('MSC'
, 'COMPANY_ID')
, PUBLISHER_ID
, PRIMARY_QUANTITY
, DECODE(PUBLISHER_ID
, CUSTOMER_ID
, SUPPLIER_ID
, CUSTOMER_ID)
, TP_QUANTITY
, QUANTITY)
, 0) AS PURCHASE_ORDER
, DECODE(PUBLISHER_ORDER_TYPE
, 14
, DECODE(SYS_CONTEXT('MSC'
, 'COMPANY_ID')
, PUBLISHER_ID
, PRIMARY_QUANTITY
, DECODE(PUBLISHER_ID
, CUSTOMER_ID
, SUPPLIER_ID
, CUSTOMER_ID)
, TP_QUANTITY
, QUANTITY)
, 0) AS SALES_ORDER
, DECODE(PUBLISHER_ORDER_TYPE
, 15
, DECODE(SYS_CONTEXT('MSC'
, 'COMPANY_ID')
, PUBLISHER_ID
, PRIMARY_QUANTITY
, DECODE(PUBLISHER_ID
, CUSTOMER_ID
, SUPPLIER_ID
, CUSTOMER_ID)
, TP_QUANTITY
, QUANTITY)
, 0) AS ASN
, DECODE(PUBLISHER_ORDER_TYPE
, 16
, DECODE(SYS_CONTEXT('MSC'
, 'COMPANY_ID')
, PUBLISHER_ID
, PRIMARY_QUANTITY
, DECODE(PUBLISHER_ID
, CUSTOMER_ID
, SUPPLIER_ID
, CUSTOMER_ID)
, TP_QUANTITY
, QUANTITY)
, 0) AS SHIPMENT_RECEIPT
, DECODE(PUBLISHER_ORDER_TYPE
, 19
, DECODE(SYS_CONTEXT('MSC'
, 'COMPANY_ID')
, PUBLISHER_ID
, PRIMARY_QUANTITY
, DECODE(PUBLISHER_ID
, CUSTOMER_ID
, SUPPLIER_ID
, CUSTOMER_ID)
, TP_QUANTITY
, QUANTITY)
, 0) AS REPLENISHMENT
, DECODE(PUBLISHER_ORDER_TYPE
, 20
, DECODE(SYS_CONTEXT('MSC'
, 'COMPANY_ID')
, PUBLISHER_ID
, PRIMARY_QUANTITY
, DECODE(PUBLISHER_ID
, CUSTOMER_ID
, SUPPLIER_ID
, CUSTOMER_ID)
, TP_QUANTITY
, QUANTITY)
, 0) AS REQUISITION
, DECODE(PUBLISHER_ORDER_TYPE
, 21
, DECODE(SYS_CONTEXT('MSC'
, 'COMPANY_ID')
, PUBLISHER_ID
, PRIMARY_QUANTITY
, DECODE(PUBLISHER_ID
, CUSTOMER_ID
, SUPPLIER_ID
, CUSTOMER_ID)
, TP_QUANTITY
, QUANTITY)
, 0) AS PO_ACKNOWLEDGE
, ITEM_NAME
, SUPPLIER_NAME AS SUPPLIER_NAME
, SUPPLIER_SITE_NAME AS SUPPLIER_SITE_NAME
, CUSTOMER_NAME AS CUSTOMER_NAME
, CUSTOMER_SITE_NAME AS CUSTOMER_SITE_NAME
, PUBLISHER_NAME AS DOCUMENT_OWNER
, KEY_DATE AS START_DATE
FROM MSC_SUP_DEM_ENTRIES_UI_V
WHERE CUSTOMER_ID IS NOT NULL
AND SUPPLIER_ID IS NOT NULL
AND KEY_DATE IS NOT NULL
AND PUBLISHER_ORDER_TYPE != 17

Columns

Name
SALES_FORECAST
ORDER_FORECAST
SUPPLY_COMMIT
HISTORICAL_SALES
SELL_THROUGH_FORECAST
NEGOTIATED_CAPACITY
SAFETY_STOCK
ALLOCATED_ONHAND
UNALLOCATED_ONHAND
PURCHASE_ORDER
SALES_ORDER
ASN
SHIPMENT_RECEIPT
REPLENISHMENT
REQUISITION
PO_ACKNOWLEDGE
ITEM_NAME
SUPPLIER_NAME
SUPPLIER_SITE_NAME
CUSTOMER_NAME
CUSTOMER_SITE_NAME
DOCUMENT_OWNER
START_DATE