View: PJM_PROJECT_QUOT_V

Product:	PJM - Project Manufacturing
Description:	Project related quotation information for the Web Inquiry.
Implementation/DBA Data:	APPS.PJM_PROJECT_QUOT_V

View Text

SELECT DISTINCT LINE.PROJECT_ID
, LINE.TASK_ID
, POH.PO_HEADER_ID
, POH.SEGMENT1
, POLC1.DISPLAYED_FIELD
, POLC2.DISPLAYED_FIELD
, POLC.DISPLAYED_FIELD
, POH1.PO_HEADER_ID
, POH1.SEGMENT1
, POH.START_DATE
, POH.END_DATE
, POH.VENDOR_ID
, POV.VENDOR_NAME
, POH.AGENT_ID
, PO_INQ_SV.GET_PERSON_NAME(POH.AGENT_ID)
FROM PO_LOOKUP_CODES POLC
, PO_LOOKUP_CODES POLC1
, PO_LOOKUP_CODES POLC2
, PO_VENDORS POV
, PO_HEADERS POH
, PO_HEADERS POH1
, PO_LINES LINE
WHERE POLC.LOOKUP_CODE (+) = NVL(POH.STATUS_LOOKUP_CODE
, 'I')
AND POLC.LOOKUP_TYPE = 'RFQ/QUOTE STATUS'
AND POLC1.LOOKUP_CODE (+) = NVL(POH.QUOTE_TYPE_LOOKUP_CODE
, 'STANDARD')
AND POLC1.LOOKUP_TYPE = 'QUOTATION SUBTYPE'
AND POLC2.LOOKUP_CODE (+) = NVL(POH.QUOTATION_CLASS_CODE
, 'CATALOG')
AND POLC2.LOOKUP_TYPE = 'QUOTATION CLASS'
AND POH1.PO_HEADER_ID (+) = POH.FROM_HEADER_ID
AND POH.TYPE_LOOKUP_CODE = 'QUOTATION'
AND LINE.PO_HEADER_ID = POH.PO_HEADER_ID
AND POV.VENDOR_ID (+) = POH.VENDOR_ID

Columns