VIEW: APPS.PO_RFQ_HEADERS_PRINT

Source

View Text - Preformatted

SELECT POH.SEGMENT1 , POH.REVISION_NUM , POH.CREATION_DATE , PRV.PRINTED_DATE , POH.REVISED_DATE , POH.RFQ_CLOSE_DATE , POH.REPLY_DATE , POH.START_DATE , POH.END_DATE , POH.NOTE_TO_VENDOR , HRE.FIRST_NAME , HRE.LAST_NAME ,POH.SHIP_VIA_LOOKUP_CODE SHIP_VIA , PLC1.DISPLAYED_FIELD , PLC2.DISPLAYED_FIELD , POH.REPLY_METHOD_LOOKUP_CODE , APT.NAME , POV.CUSTOMER_NUM , POV.SEGMENT1 , POV.VENDOR_NAME , PVS.ADDRESS_LINE1 , PVS.ADDRESS_LINE2 , PVS.ADDRESS_LINE3 , PVS.CITY , PVS.STATE , PVS.ZIP , PVS.COUNTRY , '('||PVS.AREA_CODE||') '||PVS.PHONE , PVC.FIRST_NAME , PVC.LAST_NAME , '('||PVC.AREA_CODE||') '||PVC.PHONE , HR1.ADDRESS_LINE_1 , HR1.ADDRESS_LINE_2 , HR1.ADDRESS_LINE_3 , HR1.TOWN_OR_CITY , NVL(DECODE(HR1.REGION_1, NULL, HR1.REGION_2, DECODE(FCL1.MEANING, NULL, DECODE(FCL2.MEANING, NULL,FCL3.MEANING, FCL2.LOOKUP_CODE) , FCL1.LOOKUP_CODE)), HR1.REGION_2) , HR1.POSTAL_CODE , HR1.COUNTRY , HR2.ADDRESS_LINE_1 , HR2.ADDRESS_LINE_2 , HR2.ADDRESS_LINE_3 , HR2.TOWN_OR_CITY , NVL(DECODE(HR2.REGION_1, NULL, HR2.REGION_2, DECODE(FCL4.MEANING, NULL, DECODE(FCL5.MEANING, NULL,FCL6.MEANING, FCL5.LOOKUP_CODE), FCL4.LOOKUP_CODE) ) , HR2.REGION_2) , HR2.POSTAL_CODE , HR2.COUNTRY , 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.BILL_TO_LOCATION_ID , POH.SHIP_TO_LOCATION_ID , POH.AGENT_ID , POH.PO_HEADER_ID , POH.CURRENCY_CODE , PVS.LANGUAGE , PRV.SEQUENCE_NUM , POH.ORG_ID FROM PO_VENDORS POV , PO_VENDOR_SITES_ALL PVS , PO_VENDOR_CONTACTS PVC , HR_EMPLOYEES HRE , AP_TERMS APT , PO_RFQ_VENDORS PRV , PO_HEADERS POH , HR_LOCATIONS hr1 , HR_LOCATIONS hr2 , po_lookup_codes plc1 , po_lookup_codes plc2 , FND_LOOKUP_VALUES FCL1 , FND_LOOKUP_VALUES FCL2 , FND_LOOKUP_VALUES FCL3 , FND_LOOKUP_VALUES FCL4 , FND_LOOKUP_VALUES FCL5 , FND_LOOKUP_VALUES FCL6 WHERE PRV.PRINT_FLAG = 'Y' AND POH.STATUS_LOOKUP_CODE IN ('A','P') AND POH.PO_HEADER_ID = PRV.PO_HEADER_ID AND POV.VENDOR_ID = PRV.VENDOR_ID AND PVS.VENDOR_SITE_ID = PRV.VENDOR_SITE_ID AND PRV.VENDOR_CONTACT_ID = PVC.VENDOR_CONTACT_ID(+) AND HRE.EMPLOYEE_ID = POH.AGENT_ID AND POH.SHIP_TO_LOCATION_ID = HR1.LOCATION_ID (+) AND POH.BILL_TO_LOCATION_ID = HR2.LOCATION_ID (+) AND POH.TERMS_ID = APT.TERM_ID (+) AND POH.TYPE_LOOKUP_CODE = 'RFQ' AND PLC1.LOOKUP_CODE(+) =POH.FOB_LOOKUP_CODE AND PLC1.LOOKUP_TYPE(+) = 'FOB' AND PLC2.LOOKUP_CODE(+) = POH.FREIGHT_TERMS_LOOKUP_CODE AND PLC2.LOOKUP_TYPE(+) = 'FREIGHT TERMS' AND HR1.REGION_1 = FCL1.LOOKUP_CODE (+) AND HR1.COUNTRY || '_PROVINCE' = FCL1.LOOKUP_TYPE (+) AND DECODE(FCL1.LOOKUP_CODE, NULL, '1', FCL1.SECURITY_GROUP_ID) = DECODE(FCL1.LOOKUP_CODE, NULL, '1', FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL1.LOOKUP_TYPE, FCL1.VIEW_APPLICATION_ID)) AND DECODE (FCL1.LOOKUP_CODE, NULL, '1', FCL1.VIEW_APPLICATION_ID) = DECODE(FCL1.LOOKUP_CODE, NULL, '1', 3) AND DECODE(FCL1.LOOKUP_CODE, NULL, '1', FCL1.LANGUAGE ) = DECODE(FCL1.LOOKUP_CODE, NULL, '1', USERENV('LANG')) AND HR1.REGION_2 = FCL2.LOOKUP_CODE (+) AND HR1.COUNTRY || '_STATE' = FCL2.LOOKUP_TYPE (+) AND DECODE(FCL2.LOOKUP_CODE, NULL, '1', FCL2.SECURITY_GROUP_ID) = DECODE(FCL2 .LOOKUP_CODE, NULL , '1', FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL2.LOOKUP_TYPE , FCL2.VIEW_APPLICATION_ID)) AND DECODE(FCL2.LOOKUP_CODE, NULL, '1', FCL2.VIEW_APPLICATION_ID) = DECODE(FCL2.LOOKUP_CODE, NULL, '1', 3) AND DECODE(FCL2.LOOKUP_CODE, NULL , '1', FCL2.LANGUAGE) = DECODE(FCL2.LOOKUP_CODE, NULL, '1', USERENV('LANG') ) AND HR1.REGION_1 = FCL3.LOOKUP_CODE (+) AND HR1.COUNTRY || '_COUNTY' = FCL3.LOOKUP_TYPE (+) AND DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.SECURITY_GROUP_ID) = DECODE(FCL3.LOOKUP_CODE, NULL, '1', FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL3.LOOKUP_TYPE, FCL3.VIEW_APPLICATION_ID)) AND DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.VIEW_APPLICATION_ID) = DECODE(FCL3. LOOKUP_CODE, NULL, '1', 3) AND DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.LANGUAGE) = DECODE(FCL3. LOOKUP_CODE, NULL, '1', USERENV('LANG')) AND HR2.REGION_1 = FCL4.LOOKUP_CODE (+) AND HR2.COUNTRY || '_PROVINCE' = FCL4.LOOKUP_TYPE (+) AND DECODE(FCL4.LOOKUP_CODE, NULL, '1', FCL4.SECURITY_GROUP_ID) = DECODE(FCL4.LOOKUP_CODE, NULL, '1', FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL4.LOOKUP_TYPE, FCL4.VIEW_APPLICATION_ID)) AND DECODE(FCL4.LOOKUP_CODE, NULL, '1', FCL4.VIEW_APPLICATION_ID) = DECODE(FCL4.LOOKUP_CODE, NULL, '1', 3) AND DECODE(FCL4.LOOKUP_CODE, NULL, '1', FCL4.LANGUAGE) = DECODE(FCL4.LOOKUP_CODE , NULL, '1', USERENV('LANG')) AND HR2.REGION_2 = FCL5.LOOKUP_CODE (+) AND HR2.COUNTRY || '_STATE' = FCL5.LOOKUP_TYPE (+) AND DECODE(FCL5.LOOKUP_CODE, NULL, '1', FCL5.SECURITY_GROUP_ID) = DECODE(FCL5.LOOKUP_CODE, NULL, '1', FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL5.LOOKUP_TYPE, FCL5.VIEW_APPLICATION_ID)) AND DECODE(FCL5.LOOKUP_CODE, NULL, '1', FCL5.VIEW_APPLICATION_ID) = DECODE (FCL5.LOOKUP_CODE, NULL , '1', 3) AND DECODE(FCL5.LOOKUP_CODE, NULL, '1', FCL5.LANGUAGE) = DECODE(FCL5.LOOKUP_CODE, NULL, '1', USERENV('LANG')) AND HR2.REGION_1 = FCL6.LOOKUP_CODE (+) AND HR2.COUNTRY || '_COUNTY' = FCL6.LOOKUP_TYPE (+) AND DECODE(FCL6.LOOKUP_CODE, NULL, '1', FCL6.SECURITY_GROUP_ID) = DECODE(FCL6.LOOKUP_CODE, NULL, '1', FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL6.LOOKUP_TYPE, FCL6.VIEW_APPLICATION_ID)) AND DECODE(FCL6.LOOKUP_CODE, NULL, '1', FCL6.VIEW_APPLICATION_ID) = DECODE(FCL6.LOOKUP_CODE, NULL, '1', 3) AND DECODE(FCL6.LOOKUP_CODE, NULL, '1', FCL6.LANGUAGE) = DECODE(FCL6.LOOKUP_CODE, NULL, '1', USERENV( 'LANG'))

View Text - HTML Formatted

SELECT POH.SEGMENT1
, POH.REVISION_NUM
, POH.CREATION_DATE
, PRV.PRINTED_DATE
, POH.REVISED_DATE
, POH.RFQ_CLOSE_DATE
, POH.REPLY_DATE
, POH.START_DATE
, POH.END_DATE
, POH.NOTE_TO_VENDOR
, HRE.FIRST_NAME
, HRE.LAST_NAME
, POH.SHIP_VIA_LOOKUP_CODE SHIP_VIA
, PLC1.DISPLAYED_FIELD
, PLC2.DISPLAYED_FIELD
, POH.REPLY_METHOD_LOOKUP_CODE
, APT.NAME
, POV.CUSTOMER_NUM
, POV.SEGMENT1
, POV.VENDOR_NAME
, PVS.ADDRESS_LINE1
, PVS.ADDRESS_LINE2
, PVS.ADDRESS_LINE3
, PVS.CITY
, PVS.STATE
, PVS.ZIP
, PVS.COUNTRY
, '('||PVS.AREA_CODE||') '||PVS.PHONE
, PVC.FIRST_NAME
, PVC.LAST_NAME
, '('||PVC.AREA_CODE||') '||PVC.PHONE
, HR1.ADDRESS_LINE_1
, HR1.ADDRESS_LINE_2
, HR1.ADDRESS_LINE_3
, HR1.TOWN_OR_CITY
, NVL(DECODE(HR1.REGION_1
, NULL
, HR1.REGION_2
, DECODE(FCL1.MEANING
, NULL
, DECODE(FCL2.MEANING
, NULL
, FCL3.MEANING
, FCL2.LOOKUP_CODE)
, FCL1.LOOKUP_CODE))
, HR1.REGION_2)
, HR1.POSTAL_CODE
, HR1.COUNTRY
, HR2.ADDRESS_LINE_1
, HR2.ADDRESS_LINE_2
, HR2.ADDRESS_LINE_3
, HR2.TOWN_OR_CITY
, NVL(DECODE(HR2.REGION_1
, NULL
, HR2.REGION_2
, DECODE(FCL4.MEANING
, NULL
, DECODE(FCL5.MEANING
, NULL
, FCL6.MEANING
, FCL5.LOOKUP_CODE)
, FCL4.LOOKUP_CODE) )
, HR2.REGION_2)
, HR2.POSTAL_CODE
, HR2.COUNTRY
, 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.BILL_TO_LOCATION_ID
, POH.SHIP_TO_LOCATION_ID
, POH.AGENT_ID
, POH.PO_HEADER_ID
, POH.CURRENCY_CODE
, PVS.LANGUAGE
, PRV.SEQUENCE_NUM
, POH.ORG_ID
FROM PO_VENDORS POV
, PO_VENDOR_SITES_ALL PVS
, PO_VENDOR_CONTACTS PVC
, HR_EMPLOYEES HRE
, AP_TERMS APT
, PO_RFQ_VENDORS PRV
, PO_HEADERS POH
, HR_LOCATIONS HR1
, HR_LOCATIONS HR2
, PO_LOOKUP_CODES PLC1
, PO_LOOKUP_CODES PLC2
, FND_LOOKUP_VALUES FCL1
, FND_LOOKUP_VALUES FCL2
, FND_LOOKUP_VALUES FCL3
, FND_LOOKUP_VALUES FCL4
, FND_LOOKUP_VALUES FCL5
, FND_LOOKUP_VALUES FCL6
WHERE PRV.PRINT_FLAG = 'Y'
AND POH.STATUS_LOOKUP_CODE IN ('A'
, 'P')
AND POH.PO_HEADER_ID = PRV.PO_HEADER_ID
AND POV.VENDOR_ID = PRV.VENDOR_ID
AND PVS.VENDOR_SITE_ID = PRV.VENDOR_SITE_ID
AND PRV.VENDOR_CONTACT_ID = PVC.VENDOR_CONTACT_ID(+)
AND HRE.EMPLOYEE_ID = POH.AGENT_ID
AND POH.SHIP_TO_LOCATION_ID = HR1.LOCATION_ID (+)
AND POH.BILL_TO_LOCATION_ID = HR2.LOCATION_ID (+)
AND POH.TERMS_ID = APT.TERM_ID (+)
AND POH.TYPE_LOOKUP_CODE = 'RFQ'
AND PLC1.LOOKUP_CODE(+) =POH.FOB_LOOKUP_CODE
AND PLC1.LOOKUP_TYPE(+) = 'FOB'
AND PLC2.LOOKUP_CODE(+) = POH.FREIGHT_TERMS_LOOKUP_CODE
AND PLC2.LOOKUP_TYPE(+) = 'FREIGHT TERMS'
AND HR1.REGION_1 = FCL1.LOOKUP_CODE (+)
AND HR1.COUNTRY || '_PROVINCE' = FCL1.LOOKUP_TYPE (+)
AND DECODE(FCL1.LOOKUP_CODE
, NULL
, '1'
, FCL1.SECURITY_GROUP_ID) = DECODE(FCL1.LOOKUP_CODE
, NULL
, '1'
, FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL1.LOOKUP_TYPE
, FCL1.VIEW_APPLICATION_ID))
AND DECODE (FCL1.LOOKUP_CODE
, NULL
, '1'
, FCL1.VIEW_APPLICATION_ID) = DECODE(FCL1.LOOKUP_CODE
, NULL
, '1'
, 3)
AND DECODE(FCL1.LOOKUP_CODE
, NULL
, '1'
, FCL1.LANGUAGE ) = DECODE(FCL1.LOOKUP_CODE
, NULL
, '1'
, USERENV('LANG'))
AND HR1.REGION_2 = FCL2.LOOKUP_CODE (+)
AND HR1.COUNTRY || '_STATE' = FCL2.LOOKUP_TYPE (+)
AND DECODE(FCL2.LOOKUP_CODE
, NULL
, '1'
, FCL2.SECURITY_GROUP_ID) = DECODE(FCL2 .LOOKUP_CODE
, NULL
, '1'
, FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL2.LOOKUP_TYPE
, FCL2.VIEW_APPLICATION_ID))
AND DECODE(FCL2.LOOKUP_CODE
, NULL
, '1'
, FCL2.VIEW_APPLICATION_ID) = DECODE(FCL2.LOOKUP_CODE
, NULL
, '1'
, 3)
AND DECODE(FCL2.LOOKUP_CODE
, NULL
, '1'
, FCL2.LANGUAGE) = DECODE(FCL2.LOOKUP_CODE
, NULL
, '1'
, USERENV('LANG') )
AND HR1.REGION_1 = FCL3.LOOKUP_CODE (+)
AND HR1.COUNTRY || '_COUNTY' = FCL3.LOOKUP_TYPE (+)
AND DECODE(FCL3.LOOKUP_CODE
, NULL
, '1'
, FCL3.SECURITY_GROUP_ID) = DECODE(FCL3.LOOKUP_CODE
, NULL
, '1'
, FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL3.LOOKUP_TYPE
, FCL3.VIEW_APPLICATION_ID))
AND DECODE(FCL3.LOOKUP_CODE
, NULL
, '1'
, FCL3.VIEW_APPLICATION_ID) = DECODE(FCL3. LOOKUP_CODE
, NULL
, '1'
, 3)
AND DECODE(FCL3.LOOKUP_CODE
, NULL
, '1'
, FCL3.LANGUAGE) = DECODE(FCL3. LOOKUP_CODE
, NULL
, '1'
, USERENV('LANG'))
AND HR2.REGION_1 = FCL4.LOOKUP_CODE (+)
AND HR2.COUNTRY || '_PROVINCE' = FCL4.LOOKUP_TYPE (+)
AND DECODE(FCL4.LOOKUP_CODE
, NULL
, '1'
, FCL4.SECURITY_GROUP_ID) = DECODE(FCL4.LOOKUP_CODE
, NULL
, '1'
, FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL4.LOOKUP_TYPE
, FCL4.VIEW_APPLICATION_ID))
AND DECODE(FCL4.LOOKUP_CODE
, NULL
, '1'
, FCL4.VIEW_APPLICATION_ID) = DECODE(FCL4.LOOKUP_CODE
, NULL
, '1'
, 3)
AND DECODE(FCL4.LOOKUP_CODE
, NULL
, '1'
, FCL4.LANGUAGE) = DECODE(FCL4.LOOKUP_CODE
, NULL
, '1'
, USERENV('LANG'))
AND HR2.REGION_2 = FCL5.LOOKUP_CODE (+)
AND HR2.COUNTRY || '_STATE' = FCL5.LOOKUP_TYPE (+)
AND DECODE(FCL5.LOOKUP_CODE
, NULL
, '1'
, FCL5.SECURITY_GROUP_ID) = DECODE(FCL5.LOOKUP_CODE
, NULL
, '1'
, FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL5.LOOKUP_TYPE
, FCL5.VIEW_APPLICATION_ID))
AND DECODE(FCL5.LOOKUP_CODE
, NULL
, '1'
, FCL5.VIEW_APPLICATION_ID) = DECODE (FCL5.LOOKUP_CODE
, NULL
, '1'
, 3)
AND DECODE(FCL5.LOOKUP_CODE
, NULL
, '1'
, FCL5.LANGUAGE) = DECODE(FCL5.LOOKUP_CODE
, NULL
, '1'
, USERENV('LANG'))
AND HR2.REGION_1 = FCL6.LOOKUP_CODE (+)
AND HR2.COUNTRY || '_COUNTY' = FCL6.LOOKUP_TYPE (+)
AND DECODE(FCL6.LOOKUP_CODE
, NULL
, '1'
, FCL6.SECURITY_GROUP_ID) = DECODE(FCL6.LOOKUP_CODE
, NULL
, '1'
, FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL6.LOOKUP_TYPE
, FCL6.VIEW_APPLICATION_ID))
AND DECODE(FCL6.LOOKUP_CODE
, NULL
, '1'
, FCL6.VIEW_APPLICATION_ID) = DECODE(FCL6.LOOKUP_CODE
, NULL
, '1'
, 3)
AND DECODE(FCL6.LOOKUP_CODE
, NULL
, '1'
, FCL6.LANGUAGE) = DECODE(FCL6.LOOKUP_CODE
, NULL
, '1'
, USERENV( 'LANG'))