VIEW: APPS.ICX_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 , 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

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
, 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