VIEW: APPS.ICX_PO_DISTRIBUTES_DIFF_V

Source

View Text - Preformatted

SELECT POR.LINE_SEQ , POR.HEADER_ID , POR.RELEASE_ID , POR.LINE_ID , POLA.LINE_NUM , POR.LOCATION_ID , POLLA.SHIPMENT_NUM , POR.DISTRIBUTION_ID , POR.DISTRIBUTION_NUM , POLA.ITEM_ID , MSI.CONCATENATED_SEGMENTS , POR.LEVEL_ALTERED , POR.FIELD_ALTERED , POR.CHANGES_FROM , POR.CHANGES_TO FROM ICX_PO_REVISIONS_TEMP POR, PO_LINES_ARCHIVE POLA, PO_LINE_LOCATIONS_ARCHIVE POLLA, MTL_SYSTEM_ITEMS_KFV MSI WHERE POR.LEVEL_ALTERED = 'ICX_DISTRIBUTION' AND POLLA.SHIPMENT_NUM = POR.LOCATION_ID AND POLA.PO_LINE_ID = POR.LINE_ID AND MSI.INVENTORY_ITEM_ID = POLA.ITEM_ID

View Text - HTML Formatted

SELECT POR.LINE_SEQ
, POR.HEADER_ID
, POR.RELEASE_ID
, POR.LINE_ID
, POLA.LINE_NUM
, POR.LOCATION_ID
, POLLA.SHIPMENT_NUM
, POR.DISTRIBUTION_ID
, POR.DISTRIBUTION_NUM
, POLA.ITEM_ID
, MSI.CONCATENATED_SEGMENTS
, POR.LEVEL_ALTERED
, POR.FIELD_ALTERED
, POR.CHANGES_FROM
, POR.CHANGES_TO
FROM ICX_PO_REVISIONS_TEMP POR
, PO_LINES_ARCHIVE POLA
, PO_LINE_LOCATIONS_ARCHIVE POLLA
, MTL_SYSTEM_ITEMS_KFV MSI
WHERE POR.LEVEL_ALTERED = 'ICX_DISTRIBUTION'
AND POLLA.SHIPMENT_NUM = POR.LOCATION_ID
AND POLA.PO_LINE_ID = POR.LINE_ID
AND MSI.INVENTORY_ITEM_ID = POLA.ITEM_ID