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

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.POFV_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'
, '_DF:PO:PO_RFQ_VENDORS:RS'
, RS.VENDOR_ID
, VE.VENDOR_NAME
, RS.VENDOR_SITE_ID
, VS.VENDOR_SITE_CODE
, RS.VENDOR_CONTACT_ID
, VC.LAST_NAME || '
, ' || VC.FIRST_NAME
, 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
, PO_VENDORS VE
, PO_VENDOR_CONTACTS VC
, PO_VENDOR_SITES_ALL VS
WHERE RS.PO_HEADER_ID = RQ.PO_HEADER_ID
AND RQ.ORG_ID = OP.ORGANIZATION_ID
AND RS.VENDOR_ID = VE.VENDOR_ID
AND RS.VENDOR_SITE_ID = VS.VENDOR_SITE_ID
AND RQ.ORG_ID = VS.ORG_ID
AND RS.VENDOR_CONTACT_ID = VC.VENDOR_CONTACT_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"
"_DF"
SUPPLIER_ID
SUPPLIER_NAME
SUPPLIER_SITE_ID
SUPPLIER_SITE
SUPPLIER_CONTACT_ID
SUPPLIER_CONTACT_NAME
CREATED_DATE
CREATED_BY
LAST_UPDATED_DATE
LAST_UPDATED_BY