VIEW: APPS.PJM_PROJECT_RFQ_V

Source

View Text - Preformatted

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(RFQV.VENDOR_CONTACT_ID, NULL, NULL, PVC.LAST_NAME || ', ' || PVC.FIRST_NAME) ,DECODE(RFQV.VENDOR_CONTACT_ID, NULL, NULL, PVC.LAST_NAME || ', ' || PVC.FIRST_NAME) , POH.REPLY_DATE , RFQ_CLOSE_DATE , POH.ORG_ID FROM PO_LOOKUP_CODES POLC , PO_HEADERS_ALL POH , PO_LINES_ALL LINE , PO_VENDORS POV , PO_RFQ_VENDORS RFQV , PO_VENDOR_SITES_ALL PVS , ( SELECT C.VENDOR_CONTACT_ID VENDOR_CONTACT_ID ,substr(HP.PERSON_FIRST_NAME,1,15) FIRST_NAME ,substr(HP.PERSON_MIDDLE_NAME,1,15) MIDDLE_NAME ,substr(HP.PERSON_LAST_NAME,1,15) LAST_NAME ,NVL(HP. PERSON_PRE_NAME_ADJUNCT, HP.SALUTATION) PREFIX ,substr(HP.PERSON_TITLE,30) TITLE FROM AP_SUPPLIER_CONTACTS C ,HZ_PARTIES HP WHERE C.PER_PARTY_ID = HP.PARTY_ID ) 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

View Text - HTML Formatted

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(RFQV.VENDOR_CONTACT_ID
, NULL
, NULL
, PVC.LAST_NAME || '
, ' || PVC.FIRST_NAME)
, DECODE(RFQV.VENDOR_CONTACT_ID
, NULL
, NULL
, PVC.LAST_NAME || '
, ' || PVC.FIRST_NAME)
, POH.REPLY_DATE
, RFQ_CLOSE_DATE
, POH.ORG_ID
FROM PO_LOOKUP_CODES POLC
, PO_HEADERS_ALL POH
, PO_LINES_ALL LINE
, PO_VENDORS POV
, PO_RFQ_VENDORS RFQV
, PO_VENDOR_SITES_ALL PVS
, ( SELECT C.VENDOR_CONTACT_ID VENDOR_CONTACT_ID
, SUBSTR(HP.PERSON_FIRST_NAME
, 1
, 15) FIRST_NAME
, SUBSTR(HP.PERSON_MIDDLE_NAME
, 1
, 15) MIDDLE_NAME
, SUBSTR(HP.PERSON_LAST_NAME
, 1
, 15) LAST_NAME
, NVL(HP. PERSON_PRE_NAME_ADJUNCT
, HP.SALUTATION) PREFIX
, SUBSTR(HP.PERSON_TITLE
, 30) TITLE
FROM AP_SUPPLIER_CONTACTS C
, HZ_PARTIES HP
WHERE C.PER_PARTY_ID = HP.PARTY_ID ) 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