VIEW: APPS.PO_HEADERS_RFQQT_V

Source

View Text - Preformatted

SELECT POH.ROWID , POH.PO_HEADER_ID , POH.SEGMENT1 , POH.SEGMENT2 , POH.SEGMENT3 , POH.SEGMENT4 , POH.SEGMENT5 , PODT.TYPE_NAME , POH.TYPE_LOOKUP_CODE , POLC.DISPLAYED_FIELD , POH.STATUS_LOOKUP_CODE , POH.REVISION_NUM , POH.VENDOR_ID , POV.VENDOR_NAME , POH.VENDOR_SITE_ID , PVS.VENDOR_SITE_CODE , POH.VENDOR_CONTACT_ID , DECODE(POH.VENDOR_CONTACT_ID,NULL,NULL,PVC.LAST_NAME || ', ' || PVC.FIRST_NAME) , POH.AGENT_ID , PPF.FULL_NAME , POH.QUOTE_VENDOR_QUOTE_NUMBER , POH.FROM_HEADER_ID , POH.FROM_TYPE_LOOKUP_CODE , POH2.SEGMENT1 , POH.RFQ_CLOSE_DATE , POH.REPLY_METHOD_LOOKUP_CODE , POH.REPLY_DATE , POH.START_DATE , POH.END_DATE , POH.SHIP_TO_LOCATION_ID , HRL1.LOCATION_CODE , POH.BILL_TO_LOCATION_ID , HRL2.LOCATION_CODE , POH.APPROVAL_REQUIRED_FLAG , POH.CURRENCY_CODE , GLC.USER_CONVERSION_TYPE , POH.RATE_TYPE , POH.RATE_DATE , POH.RATE , POH.COMMENTS , POH.TERMS_ID , APT.NAME , POH.FREIGHT_TERMS_LOOKUP_CODE , POLC3.DISPLAYED_FIELD , POH.SHIP_VIA_LOOKUP_CODE , POH.FOB_LOOKUP_CODE , POLC2.DISPLAYED_FIELD , POH.NOTE_TO_VENDOR , POH.QUOTE_WARNING_DELAY , POH.QUOTATION_CLASS_CODE , POH.PRINTED_DATE , POH.REVISED_DATE , POH.CLOSED_DATE , POH.QUOTE_TYPE_LOOKUP_CODE , POH.SUMMARY_FLAG , POH.ENABLED_FLAG , POH.LAST_UPDATED_BY , POH.LAST_UPDATE_DATE , POH.LAST_UPDATE_LOGIN , POH.CREATED_BY , POH.CREATION_DATE , POH.CREATION_DATE , POH.PROGRAM_APPLICATION_ID , POH.PROGRAM_ID , POH.PROGRAM_UPDATE_DATE , POH.REQUEST_ID , 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.ATTRIBUTE_CATEGORY , POH.ORG_ID , PODB_STD.SECURITY_LEVEL_CODE , PODB_STD.ACCESS_LEVEL_CODE FROM PO_HEADERS POH, PER_PEOPLE_F PPF, PO_VENDORS POV, PO_VENDOR_SITES_ALL PVS, PO_VENDOR_CONTACTS PVC, AP_TERMS APT, HR_LOCATIONS_ALL_TL HRL1, HR_LOCATIONS_ALL_TL HRL2, GL_DAILY_CONVERSION_TYPES GLC, PO_LOOKUP_CODES POLC, PO_LOOKUP_CODES POLC2, PO_LOOKUP_CODES POLC3, PO_DOCUMENT_TYPES_ALL_TL PODT, PO_DOCUMENT_TYPES_ALL_B PODB, PO_DOCUMENT_TYPES_ALL_B PODB_STD, PO_HEADERS_ALL POH2 WHERE PPF.PERSON_ID = POH.AGENT_ID AND TRUNC(SYSDATE) BETWEEN PPF.EFFECTIVE_START_DATE AND PPF.EFFECTIVE_END_DATE AND POV.VENDOR_ID(+) = POH.VENDOR_ID AND PVS.VENDOR_SITE_ID(+) = POH.VENDOR_SITE_ID AND PVC.VENDOR_CONTACT_ID(+) = POH.VENDOR_CONTACT_ID AND PVC.VENDOR_SITE_ID(+) = POH.VENDOR_SITE_ID AND APT.TERM_ID(+) = POH.TERMS_ID AND HRL1.LOCATION_ID(+) = POH.SHIP_TO_LOCATION_ID AND HRL1.LANGUAGE (+) = USERENV('LANG') AND HRL2.LOCATION_ID(+) = POH.BILL_TO_LOCATION_ID AND HRL2.LANGUAGE (+) = USERENV('LANG') AND GLC.CONVERSION_TYPE(+) = POH.RATE_TYPE AND POLC.LOOKUP_TYPE = 'RFQ/QUOTE STATUS' AND POLC.LOOKUP_CODE = POH.STATUS_LOOKUP_CODE AND POLC2.LOOKUP_CODE (+) = POH.FOB_LOOKUP_CODE AND POLC2.LOOKUP_TYPE (+) = 'FOB' AND POLC3.LOOKUP_CODE (+) = POH.FREIGHT_TERMS_LOOKUP_CODE AND POLC3.LOOKUP_TYPE (+) = 'FREIGHT TERMS' AND POH2.PO_HEADER_ID(+) = POH.FROM_HEADER_ID AND PODB.DOCUMENT_TYPE_CODE = POH.TYPE_LOOKUP_CODE AND PODB.DOCUMENT_SUBTYPE = POH.QUOTE_TYPE_LOOKUP_CODE AND PODB.QUOTATION_CLASS_CODE = POH.QUOTATION_CLASS_CODE AND PODB.ORG_ID = POH.ORG_ID AND PODB_STD.DOCUMENT_TYPE_CODE = POH.TYPE_LOOKUP_CODE AND PODB_STD.DOCUMENT_SUBTYPE = 'STANDARD' AND PODB_STD.ORG_ID = POH.ORG_ID AND POH.TYPE_LOOKUP_CODE IN ('RFQ', 'QUOTATION') AND PODB.DOCUMENT_TYPE_CODE = PODT.DOCUMENT_TYPE_CODE AND PODB.DOCUMENT_SUBTYPE = PODT.DOCUMENT_SUBTYPE AND PODB.ORG_ID = PODT.ORG_ID AND PODT.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT POH.ROWID
, POH.PO_HEADER_ID
, POH.SEGMENT1
, POH.SEGMENT2
, POH.SEGMENT3
, POH.SEGMENT4
, POH.SEGMENT5
, PODT.TYPE_NAME
, POH.TYPE_LOOKUP_CODE
, POLC.DISPLAYED_FIELD
, POH.STATUS_LOOKUP_CODE
, POH.REVISION_NUM
, POH.VENDOR_ID
, POV.VENDOR_NAME
, POH.VENDOR_SITE_ID
, PVS.VENDOR_SITE_CODE
, POH.VENDOR_CONTACT_ID
, DECODE(POH.VENDOR_CONTACT_ID
, NULL
, NULL
, PVC.LAST_NAME || '
, ' || PVC.FIRST_NAME)
, POH.AGENT_ID
, PPF.FULL_NAME
, POH.QUOTE_VENDOR_QUOTE_NUMBER
, POH.FROM_HEADER_ID
, POH.FROM_TYPE_LOOKUP_CODE
, POH2.SEGMENT1
, POH.RFQ_CLOSE_DATE
, POH.REPLY_METHOD_LOOKUP_CODE
, POH.REPLY_DATE
, POH.START_DATE
, POH.END_DATE
, POH.SHIP_TO_LOCATION_ID
, HRL1.LOCATION_CODE
, POH.BILL_TO_LOCATION_ID
, HRL2.LOCATION_CODE
, POH.APPROVAL_REQUIRED_FLAG
, POH.CURRENCY_CODE
, GLC.USER_CONVERSION_TYPE
, POH.RATE_TYPE
, POH.RATE_DATE
, POH.RATE
, POH.COMMENTS
, POH.TERMS_ID
, APT.NAME
, POH.FREIGHT_TERMS_LOOKUP_CODE
, POLC3.DISPLAYED_FIELD
, POH.SHIP_VIA_LOOKUP_CODE
, POH.FOB_LOOKUP_CODE
, POLC2.DISPLAYED_FIELD
, POH.NOTE_TO_VENDOR
, POH.QUOTE_WARNING_DELAY
, POH.QUOTATION_CLASS_CODE
, POH.PRINTED_DATE
, POH.REVISED_DATE
, POH.CLOSED_DATE
, POH.QUOTE_TYPE_LOOKUP_CODE
, POH.SUMMARY_FLAG
, POH.ENABLED_FLAG
, POH.LAST_UPDATED_BY
, POH.LAST_UPDATE_DATE
, POH.LAST_UPDATE_LOGIN
, POH.CREATED_BY
, POH.CREATION_DATE
, POH.CREATION_DATE
, POH.PROGRAM_APPLICATION_ID
, POH.PROGRAM_ID
, POH.PROGRAM_UPDATE_DATE
, POH.REQUEST_ID
, 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.ATTRIBUTE_CATEGORY
, POH.ORG_ID
, PODB_STD.SECURITY_LEVEL_CODE
, PODB_STD.ACCESS_LEVEL_CODE
FROM PO_HEADERS POH
, PER_PEOPLE_F PPF
, PO_VENDORS POV
, PO_VENDOR_SITES_ALL PVS
, PO_VENDOR_CONTACTS PVC
, AP_TERMS APT
, HR_LOCATIONS_ALL_TL HRL1
, HR_LOCATIONS_ALL_TL HRL2
, GL_DAILY_CONVERSION_TYPES GLC
, PO_LOOKUP_CODES POLC
, PO_LOOKUP_CODES POLC2
, PO_LOOKUP_CODES POLC3
, PO_DOCUMENT_TYPES_ALL_TL PODT
, PO_DOCUMENT_TYPES_ALL_B PODB
, PO_DOCUMENT_TYPES_ALL_B PODB_STD
, PO_HEADERS_ALL POH2
WHERE PPF.PERSON_ID = POH.AGENT_ID
AND TRUNC(SYSDATE) BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND POV.VENDOR_ID(+) = POH.VENDOR_ID
AND PVS.VENDOR_SITE_ID(+) = POH.VENDOR_SITE_ID
AND PVC.VENDOR_CONTACT_ID(+) = POH.VENDOR_CONTACT_ID
AND PVC.VENDOR_SITE_ID(+) = POH.VENDOR_SITE_ID
AND APT.TERM_ID(+) = POH.TERMS_ID
AND HRL1.LOCATION_ID(+) = POH.SHIP_TO_LOCATION_ID
AND HRL1.LANGUAGE (+) = USERENV('LANG')
AND HRL2.LOCATION_ID(+) = POH.BILL_TO_LOCATION_ID
AND HRL2.LANGUAGE (+) = USERENV('LANG')
AND GLC.CONVERSION_TYPE(+) = POH.RATE_TYPE
AND POLC.LOOKUP_TYPE = 'RFQ/QUOTE STATUS'
AND POLC.LOOKUP_CODE = POH.STATUS_LOOKUP_CODE
AND POLC2.LOOKUP_CODE (+) = POH.FOB_LOOKUP_CODE
AND POLC2.LOOKUP_TYPE (+) = 'FOB'
AND POLC3.LOOKUP_CODE (+) = POH.FREIGHT_TERMS_LOOKUP_CODE
AND POLC3.LOOKUP_TYPE (+) = 'FREIGHT TERMS'
AND POH2.PO_HEADER_ID(+) = POH.FROM_HEADER_ID
AND PODB.DOCUMENT_TYPE_CODE = POH.TYPE_LOOKUP_CODE
AND PODB.DOCUMENT_SUBTYPE = POH.QUOTE_TYPE_LOOKUP_CODE
AND PODB.QUOTATION_CLASS_CODE = POH.QUOTATION_CLASS_CODE
AND PODB.ORG_ID = POH.ORG_ID
AND PODB_STD.DOCUMENT_TYPE_CODE = POH.TYPE_LOOKUP_CODE
AND PODB_STD.DOCUMENT_SUBTYPE = 'STANDARD'
AND PODB_STD.ORG_ID = POH.ORG_ID
AND POH.TYPE_LOOKUP_CODE IN ('RFQ'
, 'QUOTATION')
AND PODB.DOCUMENT_TYPE_CODE = PODT.DOCUMENT_TYPE_CODE
AND PODB.DOCUMENT_SUBTYPE = PODT.DOCUMENT_SUBTYPE
AND PODB.ORG_ID = PODT.ORG_ID
AND PODT.LANGUAGE = USERENV('LANG')