View: POS_PO_REVISIONS_TEMP_V

Product:	PO - Purchasing
Description:
Implementation/DBA Data:	APPS.POS_PO_REVISIONS_TEMP_V

View Text

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
, POS_GET.ITEM_FLEX_SEG(MSI.ROWID)
, 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 MSI
, FINANCIALS_SYSTEM_PARAMS_ALL 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

Columns