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: POBV_RFQ_SUPPLIERS

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.POBV_RFQ_SUPPLIERS

View Text

SELECT RS.PO_HEADER_ID
, RQ.SEGMENT1
, RQ.ORG_ID
, OP.NAME
, RS.SEQUENCE_NUM
, RS.PRINTED_DATE
, RS.PRINT_COUNT
, '_LA:RS.PRINT_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, RS.VENDOR_ID
, RS.VENDOR_SITE_ID
, RS.VENDOR_CONTACT_ID
, RS.CREATION_DATE
, RS.CREATED_BY
, RS.LAST_UPDATE_DATE
, RS.LAST_UPDATED_BY
FROM PO_RFQ_VENDORS RS
, PO_HEADERS_ALL RQ
, HR_ALL_ORGANIZATION_UNITS OP
WHERE RS.PO_HEADER_ID = RQ.PO_HEADER_ID
AND RQ.ORG_ID = OP.ORGANIZATION_ID
AND '_SEC:RQ.ORG_ID' IS NOT NULL WITH READ ONLY

Columns

Name
RFQ_ID
RFQ_DOCUMENT_NUMBER
OPERATING_UNIT_ID
OPERATING_UNIT_NAME
SEQUENCE_NUMBER
LAST_PRINTED_DATE
PRINT_COUNT
"_LA:REPRINT_FOR_SUPPLIER"
SUPPLIER_ID
SUPPLIER_SITE_ID
SUPPLIER_CONTACT_ID
CREATED_DATE
CREATED_BY
LAST_UPDATED_DATE
LAST_UPDATED_BY