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.

VIEW: ICX.ICX_POR_CONTRACT_REFERENCES#

Source

View Text - Preformatted


select JOB_NUMBER JOB_NUMBER, LINE_NUMBER LINE_NUMBER, BUYER_ID BUYER_ID, BUYER_NAME BUYER_NAME, CONTRACT_REFERENCE_ID CONTRACT_REFERENCE_ID, CONTRACT_REFERENCE_NUM CONTRACT_REFERENCE_NUM, SUPPLIER_ID SUPPLIER_ID, SUPPLIER_SITE SUPPLIER_SITE, PRICELIST_ID PRICELIST_ID, CURRENCY_CODE CURRENCY_CODE, ERROR_MESSAGE ERROR_MESSAGE, REQUEST_ID REQUEST_ID, SUPPLIER_SITE_ID SUPPLIER_SITE_ID from "ICX"."ICX_POR_CONTRACT_REFERENCES"

View Text - HTML Formatted

SELECT JOB_NUMBER JOB_NUMBER
, LINE_NUMBER LINE_NUMBER
, BUYER_ID BUYER_ID
, BUYER_NAME BUYER_NAME
, CONTRACT_REFERENCE_ID CONTRACT_REFERENCE_ID
, CONTRACT_REFERENCE_NUM CONTRACT_REFERENCE_NUM
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER_SITE SUPPLIER_SITE
, PRICELIST_ID PRICELIST_ID
, CURRENCY_CODE CURRENCY_CODE
, ERROR_MESSAGE ERROR_MESSAGE
, REQUEST_ID REQUEST_ID
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
FROM "ICX"."ICX_POR_CONTRACT_REFERENCES"