[Home] [Help]
View: ICX_PO_LOCATIONS_DIFF_V
View Text
SELECT POR.LINE_SEQ
, POR.HEADER_ID
, POR.RELEASE_ID
, POR.LINE_ID
, POLA.LINE_NUM
, POLA.ITEM_ID
, MSI.CONCATENATED_SEGMENTS
, POR.LOCATION_ID
, POR.LOCATION_NUM
, POR.LEVEL_ALTERED
, POR.FIELD_ALTERED
, POR.CHANGES_FROM
, POR.CHANGES_TO
FROM ICX_PO_REVISIONS_TEMP POR
, PO_LINES_ARCHIVE POLA
, MTL_SYSTEM_ITEMS_KFV MSI
WHERE POR.LEVEL_ALTERED = 'ICX_LOCATION'
AND POLA.PO_LINE_ID = POR.LINE_ID
AND MSI.INVENTORY_ITEM_ID = POLA.ITEM_ID
Columns
| Name |
| LINE_SEQ |
| HEADER_ID |
| RELEASE_ID |
| LINE_ID |
| LINE_NUM |
| ITEM_ID |
| ITEM_NUM |
| LOCATION_ID |
| LOCATION_NUM |
| LEVEL_ALTERED |
| FIELD_ALTERED |
| CHANGES_FROM |
| CHANGES_TO |
APPS.ICX_PO_LOCATIONS_DIFF_V