VIEW: APPS.CHV_CUM_ITEMS_HISTORY_V

Source

View Text - Preformatted

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 , pvs.org_id 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 (+)

View Text - HTML Formatted

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