Product: | CHV - Supplier Scheduling |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.CHV_CUM_ITEMS_V |
SELECT CCP.CUM_PERIOD_ID
, NVL( POA.PURCHASING_UNIT_OF_MEASURE
, MSI.PRIMARY_UNIT_OF_MEASURE)
, MSI.INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS
, MSI.DESCRIPTION
, POV.VENDOR_NAME
, POV.VENDOR_ID
, PVS.VENDOR_SITE_CODE
, PVS.VENDOR_SITE_ID
, HOU.ORGANIZATION_CODE
, HOU.ORGANIZATION_NAME
, HOU.ORGANIZATION_ID
, CCP.CUM_PERIOD_NAME
, CCP.CUM_PERIOD_START_DATE
, CCP.CUM_PERIOD_END_DATE
FROM MTL_SYSTEM_ITEMS_KFV MSI
, PO_VENDORS POV
, PO_VENDOR_SITES PVS
, CHV_CUM_PERIODS CCP
, ORG_ORGANIZATION_DEFINITIONS HOU
, PO_ASL_ATTRIBUTES POA
WHERE CCP.ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND POA.VENDOR_ID = POV.VENDOR_ID
AND POA.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID
AND POA.ITEM_ID = MSI.INVENTORY_ITEM_ID
AND CCP.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND POA.USING_ORGANIZATION_ID = CHV_INQ_SV.GET_ASL_ORG (CCP.ORGANIZATION_ID
, POA.VENDOR_ID
, POA.VENDOR_SITE_ID
, POA.ITEM_ID)