[Home] [Help]
View: ICX_PO_LINE_DIST_DIFF_V
View Text
SELECT POR.LINE_SEQ
, POR.HEADER_ID
, POR.RELEASE_ID
, POR.LINE_ID
, POR.LOCATION_ID
, POLLA.SHIPMENT_NUM
, POR.DISTRIBUTION_ID
, POR.DISTRIBUTION_NUM
, POR.LEVEL_ALTERED
, POR.FIELD_ALTERED
, POR.CHANGES_FROM
, POR.CHANGES_TO
FROM ICX_PO_REVISIONS_TEMP POR
, PO_LINE_LOCATIONS_ARCHIVE POLLA
WHERE POR.LEVEL_ALTERED = 'ICX_DISTRIBUTION'
AND POLLA.SHIPMENT_NUM = POR.LOCATION_ID
Columns
Name |
LINE_SEQ |
HEADER_ID |
RELEASE_ID |
LINE_ID |
LOCATION_ID |
LOCATION_NUM |
DISTRIBUTION_ID |
DISTRIBUTION_NUM |
LEVEL_ALTERED |
FIELD_ALTERED |
CHANGES_FROM |
CHANGES_TO |