View: PO_RFQ_HEADERS_PRINT

Product:	PO - Purchasing
Description:	Print view of RFQ headers
Implementation/DBA Data:	APPS.PO_RFQ_HEADERS_PRINT

View Text

SELECT POH.SEGMENT1
, POH.REVISION_NUM
, POH.CREATION_DATE
, PRV.PRINTED_DATE
, POH.REVISED_DATE
, POH.RFQ_CLOSE_DATE
, POH.REPLY_DATE
, POH.START_DATE
, POH.END_DATE
, POH.NOTE_TO_VENDOR
, HRE.FIRST_NAME
, HRE.LAST_NAME
, POH.SHIP_VIA_LOOKUP_CODE SHIP_VIA
, PLC1.DISPLAYED_FIELD
, PLC2.DISPLAYED_FIELD
, POH.REPLY_METHOD_LOOKUP_CODE
, APT.NAME
, POV.CUSTOMER_NUM
, POV.SEGMENT1
, POV.VENDOR_NAME
, PVS.ADDRESS_LINE1
, PVS.ADDRESS_LINE2
, PVS.ADDRESS_LINE3
, PVS.CITY
, PVS.STATE
, PVS.ZIP
, PVS.COUNTRY
, '('||PVS.AREA_CODE||') '||PVS.PHONE
, PVC.FIRST_NAME
, PVC.LAST_NAME
, '('||PVC.AREA_CODE||') '||PVC.PHONE
, HR1.ADDRESS_LINE_1
, HR1.ADDRESS_LINE_2
, HR1.ADDRESS_LINE_3
, HR1.TOWN_OR_CITY
, NVL(HR1.REGION_2
, HR1.REGION_1)
, HR1.POSTAL_CODE
, HR1.COUNTRY
, HR2.ADDRESS_LINE_1
, HR2.ADDRESS_LINE_2
, HR2.ADDRESS_LINE_3
, HR2.TOWN_OR_CITY
, NVL(HR2.REGION_2
, HR2.REGION_1)
, HR2.POSTAL_CODE
, HR2.COUNTRY
, POH.ATTRIBUTE1
, POH.ATTRIBUTE2
, POH.ATTRIBUTE3
, POH.ATTRIBUTE4
, POH.ATTRIBUTE5
, POH.ATTRIBUTE6
, POH.ATTRIBUTE7
, POH.ATTRIBUTE8
, POH.ATTRIBUTE9
, POH.ATTRIBUTE10
, POH.ATTRIBUTE11
, POH.ATTRIBUTE12
, POH.ATTRIBUTE13
, POH.ATTRIBUTE14
, POH.ATTRIBUTE15
, POH.BILL_TO_LOCATION_ID
, POH.SHIP_TO_LOCATION_ID
, POH.AGENT_ID
, POH.PO_HEADER_ID
, POH.CURRENCY_CODE
, PVS.LANGUAGE
, PRV.SEQUENCE_NUM
, POH.ORG_ID
FROM PO_VENDORS POV
, PO_VENDOR_SITES_ALL PVS
, PO_VENDOR_CONTACTS PVC
, HR_EMPLOYEES HRE
, AP_TERMS APT
, PO_RFQ_VENDORS PRV
, PO_HEADERS POH
, HR_LOCATIONS HR1
, HR_LOCATIONS HR2
, PO_LOOKUP_CODES PLC1
, PO_LOOKUP_CODES PLC2
WHERE PRV.PRINT_FLAG = 'Y'
AND POH.STATUS_LOOKUP_CODE IN ('A'
, 'P')
AND POH.PO_HEADER_ID = PRV.PO_HEADER_ID
AND POV.VENDOR_ID = PRV.VENDOR_ID
AND PVS.VENDOR_SITE_ID = PRV.VENDOR_SITE_ID
AND PVS.ORG_ID = POH.ORG_ID
AND PRV.VENDOR_CONTACT_ID = PVC.VENDOR_CONTACT_ID(+)
AND HRE.EMPLOYEE_ID = POH.AGENT_ID
AND POH.SHIP_TO_LOCATION_ID = HR1.LOCATION_ID (+)
AND POH.BILL_TO_LOCATION_ID = HR2.LOCATION_ID (+)
AND POH.TERMS_ID = APT.TERM_ID (+)
AND POH.TYPE_LOOKUP_CODE = 'RFQ'
AND PLC1.LOOKUP_CODE(+) =POH.FOB_LOOKUP_CODE
AND PLC1.LOOKUP_TYPE(+) = 'FOB'
AND PLC2.LOOKUP_CODE(+) = POH.FREIGHT_TERMS_LOOKUP_CODE
AND PLC2.LOOKUP_TYPE(+) = 'FREIGHT TERMS'

Columns