VIEW: APPS.POS_PO_REVISIONS_TEMP_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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