View: MSC_SUP_DEM_ENTRIES_VMI_V

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

View Text

SELECT ITEMS.PLAN_ID
, ITEMS.SR_INSTANCE_ID
, SITES.COMPANY_ID CUSTOMER_ID
, SITES.COMPANY_SITE_ID CUSTOMER_SITE_ID
, CP.COMPANY_NAME CUSTOMER_NAME
, SITES.COMPANY_SITE_NAME CUSTOMER_SITE_NAME
, SITES1.COMPANY_ID SUPPLIER_ID
, SITES1.COMPANY_SITE_ID SUPPLIER_SITE_ID
, CP1.COMPANY_NAME SUPPLIER_NAME
, SITES1.COMPANY_SITE_NAME SUPPLIER_SITE_NAME
, ITEMS.INVENTORY_ITEM_ID
, ITEMS.ITEM_NAME
, MSC_X_VMI_UTIL_NEW.GET_ORDER_DETAILS ( ITEMS.SR_INSTANCE_ID
, ITEMS.INVENTORY_ITEM_ID
, SITES.COMPANY_ID
, SITES.COMPANY_SITE_ID
, SITES1.COMPANY_ID
, SITES1.COMPANY_SITE_ID
, ITEMS.ORGANIZATION_ID
, ITEMS.SUPPLIER_ID
, ITEMS.SUPPLIER_SITE_ID ) ORDER_DETAILS
, ITEMS.PLANNER_CODE
FROM MSC_VMI_ITEM_V ITEMS
, MSC_TRADING_PARTNERS TP
, MSC_COMPANY_SITES SITES
, MSC_COMPANIES CP
, MSC_TRADING_PARTNER_MAPS MAP
, MSC_TRADING_PARTNER_MAPS MAP1
, MSC_COMPANY_SITES SITES1
, MSC_COMPANIES CP1
, MSC_TRADING_PARTNER_MAPS MAP2
WHERE ITEMS.ORGANIZATION_ID = TP.SR_TP_ID
AND ITEMS.SR_INSTANCE_ID = TP.SR_INSTANCE_ID
AND TP.PARTNER_ID = MAP.TP_KEY
AND MAP.MAP_TYPE = 2
AND MAP.COMPANY_KEY = SITES.COMPANY_SITE_ID
AND SITES.COMPANY_ID = CP.COMPANY_ID
AND ITEMS.SUPPLIER_SITE_ID = MAP1.TP_KEY
AND MAP1.MAP_TYPE = 3
AND MAP1.COMPANY_KEY = SITES1.COMPANY_SITE_ID
AND SITES1.COMPANY_ID = CP1.COMPANY_ID
AND MAP2.TP_KEY = ITEMS.SUPPLIER_ID
AND MAP2.MAP_TYPE = 1
AND EXISTS ( SELECT 1
FROM MSC_COMPANY_RELATIONSHIPS REL
WHERE MAP2.COMPANY_KEY = REL.RELATIONSHIP_ID
AND REL.RELATIONSHIP_TYPE = 2
AND REL.SUBJECT_ID = CP.COMPANY_ID
AND REL.OBJECT_ID = CP1.COMPANY_ID )

Columns