eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: ICX.ICX_PO_REVISIONS_TEMP#

Source

View Text - Preformatted


select LINE_SEQ LINE_SEQ, CREATION_DATE CREATION_DATE, HEADER_ID HEADER_ID, RELEASE_ID RELEASE_ID, LINE_ID LINE_ID, LOCATION_ID LOCATION_ID, DISTRIBUTION_ID DISTRIBUTION_ID, ITEM_ID ITEM_ID, PO_NUM PO_NUM, REVISION_NUM REVISION_NUM, LINE_NUM LINE_NUM, LOCATION_NUM LOCATION_NUM, DISTRIBUTION_NUM DISTRIBUTION_NUM, LEVEL_ALTERED LEVEL_ALTERED, FIELD_ALTERED FIELD_ALTERED, CHANGES_FROM CHANGES_FROM, CHANGES_TO CHANGES_TO, ENABLED_ORG_NAME ENABLED_ORG_NAME, LINE_NUM_DISPLAY LINE_NUM_DISPLAY from "ICX"."ICX_PO_REVISIONS_TEMP"

View Text - HTML Formatted

SELECT LINE_SEQ LINE_SEQ
, CREATION_DATE CREATION_DATE
, HEADER_ID HEADER_ID
, RELEASE_ID RELEASE_ID
, LINE_ID LINE_ID
, LOCATION_ID LOCATION_ID
, DISTRIBUTION_ID DISTRIBUTION_ID
, ITEM_ID ITEM_ID
, PO_NUM PO_NUM
, REVISION_NUM REVISION_NUM
, LINE_NUM LINE_NUM
, LOCATION_NUM LOCATION_NUM
, DISTRIBUTION_NUM DISTRIBUTION_NUM
, LEVEL_ALTERED LEVEL_ALTERED
, FIELD_ALTERED FIELD_ALTERED
, CHANGES_FROM CHANGES_FROM
, CHANGES_TO CHANGES_TO
, ENABLED_ORG_NAME ENABLED_ORG_NAME
, LINE_NUM_DISPLAY LINE_NUM_DISPLAY
FROM "ICX"."ICX_PO_REVISIONS_TEMP"