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: PO.PO_REQUISITION_SUPPLIERS#

Source

View Text - Preformatted


select REQUISITION_LINE_ID REQUISITION_LINE_ID, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, VENDOR_CONTACT_ID VENDOR_CONTACT_ID, NOTE_TO_VENDOR NOTE_TO_VENDOR, CANDIDATE_FULL_NAME CANDIDATE_FULL_NAME, DOCUMENT_TYPE_CODE DOCUMENT_TYPE_CODE, SOURCE_DOC_HEADER_ID SOURCE_DOC_HEADER_ID, SOURCE_DOC_LINE_ID SOURCE_DOC_LINE_ID, SOURCE_DOC_LINE_NUM SOURCE_DOC_LINE_NUM, UNIT_PRICE UNIT_PRICE, CURRENCY_UNIT_PRICE CURRENCY_UNIT_PRICE, AMOUNT AMOUNT, CURRENCY_AMOUNT CURRENCY_AMOUNT, CURRENCY_CODE CURRENCY_CODE, RATE_TYPE RATE_TYPE, RATE_DATE RATE_DATE, RATE RATE, PRICE_BREAK_ID PRICE_BREAK_ID, NOT_TO_EXCEED_PRICE NOT_TO_EXCEED_PRICE, ALLOW_PRICE_OVERRIDE_FLAG ALLOW_PRICE_OVERRIDE_FLAG, ALLOW_RATE_DIFFERENTIAL_FLAG ALLOW_RATE_DIFFERENTIAL_FLAG, SUPPLIER_NOTIFIED_FLAG SUPPLIER_NOTIFIED_FLAG, SUPPLIER_NOTIFIED_DATE SUPPLIER_NOTIFIED_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, REQUISITION_SUPPLIER_ID REQUISITION_SUPPLIER_ID, CANDIDATE_FIRST_NAME CANDIDATE_FIRST_NAME, CANDIDATE_LAST_NAME CANDIDATE_LAST_NAME, UNIT_MEAS_LOOKUP_CODE UNIT_MEAS_LOOKUP_CODE from "PO"."PO_REQUISITION_SUPPLIERS"

View Text - HTML Formatted

SELECT REQUISITION_LINE_ID REQUISITION_LINE_ID
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, VENDOR_CONTACT_ID VENDOR_CONTACT_ID
, NOTE_TO_VENDOR NOTE_TO_VENDOR
, CANDIDATE_FULL_NAME CANDIDATE_FULL_NAME
, DOCUMENT_TYPE_CODE DOCUMENT_TYPE_CODE
, SOURCE_DOC_HEADER_ID SOURCE_DOC_HEADER_ID
, SOURCE_DOC_LINE_ID SOURCE_DOC_LINE_ID
, SOURCE_DOC_LINE_NUM SOURCE_DOC_LINE_NUM
, UNIT_PRICE UNIT_PRICE
, CURRENCY_UNIT_PRICE CURRENCY_UNIT_PRICE
, AMOUNT AMOUNT
, CURRENCY_AMOUNT CURRENCY_AMOUNT
, CURRENCY_CODE CURRENCY_CODE
, RATE_TYPE RATE_TYPE
, RATE_DATE RATE_DATE
, RATE RATE
, PRICE_BREAK_ID PRICE_BREAK_ID
, NOT_TO_EXCEED_PRICE NOT_TO_EXCEED_PRICE
, ALLOW_PRICE_OVERRIDE_FLAG ALLOW_PRICE_OVERRIDE_FLAG
, ALLOW_RATE_DIFFERENTIAL_FLAG ALLOW_RATE_DIFFERENTIAL_FLAG
, SUPPLIER_NOTIFIED_FLAG SUPPLIER_NOTIFIED_FLAG
, SUPPLIER_NOTIFIED_DATE SUPPLIER_NOTIFIED_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, REQUISITION_SUPPLIER_ID REQUISITION_SUPPLIER_ID
, CANDIDATE_FIRST_NAME CANDIDATE_FIRST_NAME
, CANDIDATE_LAST_NAME CANDIDATE_LAST_NAME
, UNIT_MEAS_LOOKUP_CODE UNIT_MEAS_LOOKUP_CODE
FROM "PO"."PO_REQUISITION_SUPPLIERS"