View: CHV_CUM_ITEMS_HISTORY_V

Product:	CHV - Supplier Scheduling
Description:
Implementation/DBA Data:	APPS.CHV_CUM_ITEMS_HISTORY_V

View Text

SELECT POV.VENDOR_NAME
, POV.VENDOR_ID
, PVS.VENDOR_SITE_CODE
, PVS.VENDOR_SITE_ID
, MSI.CONCATENATED_SEGMENTS
, MSI.DESCRIPTION
, MSI.INVENTORY_ITEM_ID
, MSI.ORGANIZATION_ID
, PAA.PURCHASING_UNIT_OF_MEASURE
, PAA.USING_ORGANIZATION_ID
, CHV_INQ_SV2.GET_CUM_RECEIVED_PURCH(POV.VENDOR_ID
, PVS.VENDOR_SITE_ID
, MSI.INVENTORY_ITEM_ID
, CCP.ORGANIZATION_ID
, 'N'
, CCP.CUM_PERIOD_START_DATE
, CCP.CUM_PERIOD_END_DATE
, PAA.PURCHASING_UNIT_OF_MEASURE)
, CCP.CUM_PERIOD_START_DATE
, CCP.CUM_PERIOD_END_DATE
, CCP.CUM_PERIOD_NAME
, CCP.ORGANIZATION_ID
, CHV_INQ_SV2.GET_LAST_RECEIPT_NUM(CCP.ORGANIZATION_ID
, MSI.INVENTORY_ITEM_ID
, POV.VENDOR_ID
, PVS.VENDOR_SITE_ID
, CCP.CUM_PERIOD_START_DATE
, CCP.CUM_PERIOD_END_DATE)
, CHV_INQ_SV2.GET_LAST_RECEIPT_DATE(CCP.ORGANIZATION_ID
, MSI.INVENTORY_ITEM_ID
, POV.VENDOR_ID
, PVS.VENDOR_SITE_ID
, CCP.CUM_PERIOD_START_DATE
, CCP.CUM_PERIOD_END_DATE)
, CHV_INQ_SV2.GET_LAST_RECEIPT_QUANTITY(CCP.ORGANIZATION_ID
, MSI.INVENTORY_ITEM_ID
, POV.VENDOR_ID
, PVS.VENDOR_SITE_ID
, CCP.CUM_PERIOD_START_DATE
, CCP.CUM_PERIOD_END_DATE
, PAA.PURCHASING_UNIT_OF_MEASURE)
, HRE.FULL_NAME
FROM PO_VENDOR_SITES PVS
, PO_VENDORS POV
, MTL_SYSTEM_ITEMS_KFV MSI
, CHV_CUM_PERIODS CCP
, PO_ASL_ATTRIBUTES_VAL_V PAA
, HR_EMPLOYEES HRE
WHERE PAA.VENDOR_ID = POV.VENDOR_ID
AND PAA.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID
AND PAA.ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = CCP.ORGANIZATION_ID
AND PAA.SCHEDULER_ID = HRE.EMPLOYEE_ID (+)

Columns