View: PJM_PROJECT_RFQ_V

Product:	PJM - Project Manufacturing
Description:	Project related request for quotation (RFQ) information for the Web Inquiry.
Implementation/DBA Data:	APPS.PJM_PROJECT_RFQ_V

View Text

SELECT DISTINCT LINE.PROJECT_ID
, LINE.TASK_ID
, POH.PO_HEADER_ID
, POH.SEGMENT1
, POLC.DISPLAYED_FIELD
, POH.AGENT_ID
, PO_INQ_SV.GET_PERSON_NAME(POH.AGENT_ID)
, RFQV.VENDOR_ID
, POV.VENDOR_NAME
, RFQV.VENDOR_SITE_ID
, PVS.VENDOR_SITE_CODE
, RFQV.VENDOR_CONTACT_ID
, DECODE(POH.VENDOR_CONTACT_ID
, NULL
, NULL
, PVC.LAST_NAME || '
, ' || PVC.FIRST_NAME)
, DECODE(POH.VENDOR_CONTACT_ID
, NULL
, NULL
, PVC.LAST_NAME || '
, ' || PVC.FIRST_NAME)
, POH.REPLY_DATE
, RFQ_CLOSE_DATE
FROM PO_LOOKUP_CODES POLC
, PO_HEADERS POH
, PO_LINES LINE
, PO_VENDORS POV
, PO_RFQ_VENDORS RFQV
, PO_VENDOR_SITES PVS
, PO_VENDOR_CONTACTS PVC
WHERE POLC.LOOKUP_CODE(+) = NVL(POH.STATUS_LOOKUP_CODE
, 'I')
AND POLC.LOOKUP_TYPE = 'RFQ/QUOTE STATUS'
AND POH.TYPE_LOOKUP_CODE = 'RFQ'
AND LINE.PO_HEADER_ID = POH.PO_HEADER_ID
AND RFQV.PO_HEADER_ID (+) = POH.PO_HEADER_ID
AND POV.VENDOR_ID (+) = RFQV.VENDOR_ID
AND PVS.VENDOR_SITE_ID (+) = RFQV.VENDOR_SITE_ID
AND PVC.VENDOR_CONTACT_ID (+) = RFQV.VENDOR_CONTACT_ID

Columns