VIEW: APPS.CHV_CUM_ITEMS_V

Source

View Text - Preformatted

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 , PVS.ORG_ID 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)

View Text - HTML Formatted

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
, PVS.ORG_ID
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)