VIEW: APPS.PJM_PROJECT_QUOT_V

Source

View Text - Preformatted

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) , POH.ORG_ID FROM PO_LOOKUP_CODES POLC , PO_LOOKUP_CODES POLC1 , PO_LOOKUP_CODES POLC2 , PO_VENDORS POV , PO_HEADERS_ALL POH , PO_HEADERS_ALL POH1 , PO_LINES_ALL 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 LINE.ORG_ID = POH.ORG_ID AND POV.VENDOR_ID (+) = POH.VENDOR_ID

View Text - HTML Formatted

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)
, POH.ORG_ID
FROM PO_LOOKUP_CODES POLC
, PO_LOOKUP_CODES POLC1
, PO_LOOKUP_CODES POLC2
, PO_VENDORS POV
, PO_HEADERS_ALL POH
, PO_HEADERS_ALL POH1
, PO_LINES_ALL 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 LINE.ORG_ID = POH.ORG_ID
AND POV.VENDOR_ID (+) = POH.VENDOR_ID