Product: | ICX - Oracle iProcurement |
---|---|
Description: | Purchase Order Revisions View |
Implementation/DBA Data: | APPS.ICX_PO_REVISIONS_TEMP_V |
SELECT PORT.LINE_SEQ
, PORT.CREATION_DATE
, PORT.HEADER_ID
, NVL( PORT.RELEASE_ID
, -99 )
, NVL( PORT.LINE_ID
, -99 )
, NVL( PORT.LOCATION_ID
, -99 )
, NVL( PORT.DISTRIBUTION_ID
, -99 )
, PORT.ITEM_ID
, MSI.CONCATENATED_SEGMENTS
, PORT.PO_NUM
, PORT.REVISION_NUM
, PORT.LINE_NUM
, PORT.LOCATION_NUM
, PORT.DISTRIBUTION_NUM
, PORT.LEVEL_ALTERED
, ARI.ATTRIBUTE_LABEL_LONG
, PORT.CHANGES_FROM
, PORT.CHANGES_TO
FROM MTL_SYSTEM_ITEMS_KFV MSI
, FINANCIALS_SYSTEM_PARAMETERS FSP
, ICX_PO_REVISIONS_TEMP PORT
, AK_REGION_ITEMS_VL ARI
WHERE PORT.ITEM_ID = MSI.INVENTORY_ITEM_ID (+)
AND FSP.INVENTORY_ORGANIZATION_ID = NVL(MSI.ORGANIZATION_ID
, FSP.INVENTORY_ORGANIZATION_ID)
AND ARI.REGION_APPLICATION_ID = 601
AND ARI.REGION_CODE = 'ICX_PO_REVISIONS_PROMPTS'
AND ARI.ATTRIBUTE_APPLICATION_ID = 178
AND ARI.ATTRIBUTE_CODE = PORT.FIELD_ALTERED