VIEW: APPS.PO_HEADERS_CHANGE_PRINT

Source

View Text - Preformatted

SELECT POH.TYPE_LOOKUP_CODE, POH.SEGMENT1, POH.REVISION_NUM, POH.PRINT_COUNT, POH.CREATION_DATE, POH.PRINTED_DATE, POH.REVISED_DATE, POH.START_DATE, POH.END_DATE, POH.NOTE_TO_VENDOR, HRE.FIRST_NAME, HRE.LAST_NAME, POH2.AGENT_ID, HRE2.FIRST_NAME, HRE2.LAST_NAME, POH.AGENT_ID, NVL(POH.BLANKET_TOTAL_AMOUNT, '') AMOUNT_AGREED, DECODE(POH.APPROVED_FLAG,'Y','Y','N') APPROVED_FLAG, DECODE(POH.CANCEL_FLAG,'Y','Y','I','Y','N','N',NULL) CANCEL_FLAG, POH.CONFIRMING_ORDER_FLAG, POH.ACCEPTANCE_REQUIRED_FLAG, POH.ACCEPTANCE_DUE_DATE, FCC.CURRENCY_CODE, FCC.NAME, POH.RATE, POH.SHIP_VIA_LOOKUP_CODE SHIP_VIA, PLC1.DISPLAYED_FIELD, PLC2.DISPLAYED_FIELD, APT.NAME, POV.CUSTOMER_NUM, POV.SEGMENT1, POV.VENDOR_NAME, PVS.ADDRESS_LINE1, PVS.ADDRESS_LINE2, PVS.ADDRESS_LINE3, PVS.CITY, DECODE(PVS.STATE, NULL, DECODE(PVS.PROVINCE, NULL, PVS.COUNTY, PVS.PROVINCE), PVS.STATE) VENDOR_STATE, PVS.ZIP, FTE.TERRITORY_SHORT_NAME, '('||PVS.AREA_CODE||') '||PVS.PHONE VENDOR_PHONE, PVC.FIRST_NAME, PVC.LAST_NAME, '('||PVC.AREA_CODE||') '||PVC.PHONE, PO_COMMUNICATION_PVT.GETLOCATIONINFO(POH.SHIP_TO_LOCATION_ID) SHIP_TO_LOCATION_ID, PO_COMMUNICATION_PVT.GETADDRESSLINE1() SHIP_ADDRESS_LINE1, PO_COMMUNICATION_PVT.GETADDRESSLINE2() SHIP_ADDRESS_LINE2, PO_COMMUNICATION_PVT.GETADDRESSLINE3() SHIP_ADDRESS_LINE3, po_communication_pvt.gettownorcity() SHIP_CITY, po_communication_pvt.getstateorprovince() SHIP_STATE_PROVINCE, po_communication_pvt.getpostalcode() SHIP_POSTAL_CODE, po_communication_pvt.getterritoryshortname() SHIP_COUNTRY, PO_COMMUNICATION_PVT.GETLOCATIONINFO(POH.BILL_TO_LOCATION_ID) BILL_TO_LOCATION_ID, PO_COMMUNICATION_PVT.GETADDRESSLINE1() BILL_ADDRESS_LINE1, PO_COMMUNICATION_PVT.GETADDRESSLINE2() BILL_ADDRESS_LINE2, PO_COMMUNICATION_PVT.GETADDRESSLINE3() BILL_ADDRESS_LINE3, po_communication_pvt.gettownorcity() BILL_CITY, po_communication_pvt.getstateorprovince() BILL_STATE_PROVINCE, po_communication_pvt.getpostalcode() BILL_POSTAL_CODE, po_communication_pvt.getterritoryshortname() BILL_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.VENDOR_SITE_ID, POH.PO_HEADER_ID, TO_NUMBER(NULL), POH.ORG_ID, TO_NUMBER(NULL), NULL FROM PO_LOOKUP_CODES PLC1, PO_LOOKUP_CODES PLC2, PO_HEADERS_ARCHIVE POH, PO_HEADERS_ARCHIVE_ALL POH2, PO_VENDORS POV, PO_VENDOR_SITES_ALL PVS, AP_SUPPLIER_CONTACTS PVC, HR_EMPLOYEES HRE, HR_EMPLOYEES HRE2, FND_CURRENCIES_VL FCC, AP_TERMS APT, FND_TERRITORIES_TL FTE WHERE NVL(POH.USER_HOLD_FLAG,'N') = 'N' AND POV.VENDOR_ID = POH.VENDOR_ID AND PVS.VENDOR_SITE_ID = POH.VENDOR_SITE_ID AND POH.VENDOR_CONTACT_ID = PVC.VENDOR_CONTACT_ID(+) AND HRE.EMPLOYEE_ID = POH2.AGENT_ID AND HRE2.EMPLOYEE_ID = POH.AGENT_ID AND POH.TERMS_ID = APT.TERM_ID(+) AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','BLANKET', 'CONTRACT','PLANNED') AND FCC.CURRENCY_CODE = POH.CURRENCY_CODE AND NVL(POH.LATEST_EXTERNAL_FLAG,'N') = 'Y' AND POH2.REVISION_NUM = 0 AND POH.PO_HEADER_ID = POH2.PO_HEADER_ID 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 PVS.COUNTRY = FTE.TERRITORY_CODE (+) AND DECODE(fte.TERRITORY_CODE, null, '1', fte.language) = DECODE(fte.TERRITORY_CODE, null, '1', USERENV('LANG')) UNION ALL SELECT 'RELEASE' PO_TYPE, POH.SEGMENT1, POR.REVISION_NUM, POR.PRINT_COUNT, POR.CREATION_DATE, POR.PRINTED_DATE, POR.REVISED_DATE, TO_DATE(NULL), TO_DATE(NULL), POH.NOTE_TO_VENDOR, HRE.FIRST_NAME, HRE.LAST_NAME, POR2.AGENT_ID, HRE2.FIRST_NAME, HRE2.LAST_NAME, POR.AGENT_ID, TO_NUMBER(NULL), DECODE(POR.APPROVED_FLAG,'Y','Y','N') AMOUNT_AGREED, DECODE(POR.CANCEL_FLAG,'Y','Y','I','Y','N','N',NULL) APPROVED_FLAG, '' CANCEL_FLAG, POR.ACCEPTANCE_REQUIRED_FLAG, POR.ACCEPTANCE_DUE_DATE, FCC.CURRENCY_CODE, FCC.NAME, POH.RATE, POH.SHIP_VIA_LOOKUP_CODE SHIP_VIA, PLC1.DISPLAYED_FIELD, PLC2.DISPLAYED_FIELD, APT.NAME, POV.CUSTOMER_NUM, POV.SEGMENT1, POV.VENDOR_NAME, PVS.ADDRESS_LINE1, PVS.ADDRESS_LINE2, PVS.ADDRESS_LINE3, PVS.CITY, DECODE(PVS.STATE, NULL, DECODE(PVS.PROVINCE, NULL, PVS.COUNTY, PVS.PROVINCE), PVS.STATE) VENDOR_STATE, PVS.ZIP, FTE.TERRITORY_SHORT_NAME, '('||PVS.AREA_CODE||') '||PVS.PHONE VENDOR_PHONE, PVC.FIRST_NAME, PVC.LAST_NAME, '('||PVC.AREA_CODE||') '||PVC.PHONE VENDOR_CONTACT_PHONE, PO_COMMUNICATION_PVT.GETLOCATIONINFO(POH.SHIP_TO_LOCATION_ID) SHIP_TO_LOCATION_ID, PO_COMMUNICATION_PVT.GETADDRESSLINE1() SHIP_ADDRESS_LINE1, PO_COMMUNICATION_PVT.GETADDRESSLINE2() SHIP_ADDRESS_LINE2, PO_COMMUNICATION_PVT.GETADDRESSLINE3() SHIP_ADDRESS_LINE3, po_communication_pvt.gettownorcity() SHIP_CITY, po_communication_pvt.getstateorprovince() SHIP_STATE_PROVINCE, po_communication_pvt.getpostalcode() SHIP_POSTAL_CODE, po_communication_pvt.getterritoryshortname() SHIP_COUNTRY, PO_COMMUNICATION_PVT.GETLOCATIONINFO(POH.BILL_TO_LOCATION_ID) BILL_TO_LOCATION_ID, PO_COMMUNICATION_PVT.GETADDRESSLINE1() BILL_ADDRESS_LINE1, PO_COMMUNICATION_PVT.GETADDRESSLINE2() BILL_ADDRESS_LINE2, PO_COMMUNICATION_PVT.GETADDRESSLINE3() BILL_ADDRESS_LINE3, po_communication_pvt.gettownorcity() BILL_CITY, po_communication_pvt.getstateorprovince() BILL_STATE_PROVINCE, po_communication_pvt.getpostalcode() BILL_POSTAL_CODE, po_communication_pvt.getterritoryshortname() BILL_COUNTRY, POR.ATTRIBUTE1, POR.ATTRIBUTE2, POR.ATTRIBUTE3, POR.ATTRIBUTE4, POR.ATTRIBUTE5, POR.ATTRIBUTE6, POR.ATTRIBUTE7, POR.ATTRIBUTE8, POR.ATTRIBUTE9, POR.ATTRIBUTE10, POR.ATTRIBUTE11, POR.ATTRIBUTE12, POR.ATTRIBUTE13, POR.ATTRIBUTE14, POR.ATTRIBUTE15, POH.VENDOR_SITE_ID, POH.PO_HEADER_ID, POR.PO_RELEASE_ID, POR.ORG_ID, POR.RELEASE_NUM, POR.RELEASE_TYPE FROM PO_LOOKUP_CODES PLC1, PO_LOOKUP_CODES PLC2, PO_RELEASES_ARCHIVE POR, PO_RELEASES_ARCHIVE_ALL POR2, PO_HEADERS POH, PO_VENDORS POV, PO_VENDOR_SITES PVS, AP_SUPPLIER_CONTACTS PVC, HR_EMPLOYEES HRE, HR_EMPLOYEES HRE2, FND_CURRENCIES_VL FCC, FND_TERRITORIES_TL FTE, AP_TERMS APT WHERE POH.TYPE_LOOKUP_CODE IN ('BLANKET','PLANNED') AND POH.PO_HEADER_ID = POR.PO_HEADER_ID AND POV.VENDOR_ID = POH.VENDOR_ID AND PVS.VENDOR_SITE_ID = POH.VENDOR_SITE_ID AND POH.VENDOR_CONTACT_ID = PVC.VENDOR_CONTACT_ID(+) AND HRE.EMPLOYEE_ID = POR2.AGENT_ID AND HRE2.EMPLOYEE_ID = POR.AGENT_ID AND POH.TERMS_ID = APT.TERM_ID(+) AND FCC.CURRENCY_CODE = POH.CURRENCY_CODE AND NVL(POR.LATEST_EXTERNAL_FLAG,'N') = 'Y' AND POR2.REVISION_NUM = 0 AND POR.PO_RELEASE_ID = POR2.PO_RELEASE_ID 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 PVS.COUNTRY = FTE.TERRITORY_CODE (+) AND DECODE(FTE.TERRITORY_CODE, NULL, '1', FTE.LANGUAGE) = DECODE(FTE.TERRITORY_CODE, NULL, '1', USERENV('LANG'))

View Text - HTML Formatted

SELECT POH.TYPE_LOOKUP_CODE
, POH.SEGMENT1
, POH.REVISION_NUM
, POH.PRINT_COUNT
, POH.CREATION_DATE
, POH.PRINTED_DATE
, POH.REVISED_DATE
, POH.START_DATE
, POH.END_DATE
, POH.NOTE_TO_VENDOR
, HRE.FIRST_NAME
, HRE.LAST_NAME
, POH2.AGENT_ID
, HRE2.FIRST_NAME
, HRE2.LAST_NAME
, POH.AGENT_ID
, NVL(POH.BLANKET_TOTAL_AMOUNT
, '') AMOUNT_AGREED
, DECODE(POH.APPROVED_FLAG
, 'Y'
, 'Y'
, 'N') APPROVED_FLAG
, DECODE(POH.CANCEL_FLAG
, 'Y'
, 'Y'
, 'I'
, 'Y'
, 'N'
, 'N'
, NULL) CANCEL_FLAG
, POH.CONFIRMING_ORDER_FLAG
, POH.ACCEPTANCE_REQUIRED_FLAG
, POH.ACCEPTANCE_DUE_DATE
, FCC.CURRENCY_CODE
, FCC.NAME
, POH.RATE
, POH.SHIP_VIA_LOOKUP_CODE SHIP_VIA
, PLC1.DISPLAYED_FIELD
, PLC2.DISPLAYED_FIELD
, APT.NAME
, POV.CUSTOMER_NUM
, POV.SEGMENT1
, POV.VENDOR_NAME
, PVS.ADDRESS_LINE1
, PVS.ADDRESS_LINE2
, PVS.ADDRESS_LINE3
, PVS.CITY
, DECODE(PVS.STATE
, NULL
, DECODE(PVS.PROVINCE
, NULL
, PVS.COUNTY
, PVS.PROVINCE)
, PVS.STATE) VENDOR_STATE
, PVS.ZIP
, FTE.TERRITORY_SHORT_NAME
, '('||PVS.AREA_CODE||') '||PVS.PHONE VENDOR_PHONE
, PVC.FIRST_NAME
, PVC.LAST_NAME
, '('||PVC.AREA_CODE||') '||PVC.PHONE
, PO_COMMUNICATION_PVT.GETLOCATIONINFO(POH.SHIP_TO_LOCATION_ID) SHIP_TO_LOCATION_ID
, PO_COMMUNICATION_PVT.GETADDRESSLINE1() SHIP_ADDRESS_LINE1
, PO_COMMUNICATION_PVT.GETADDRESSLINE2() SHIP_ADDRESS_LINE2
, PO_COMMUNICATION_PVT.GETADDRESSLINE3() SHIP_ADDRESS_LINE3
, PO_COMMUNICATION_PVT.GETTOWNORCITY() SHIP_CITY
, PO_COMMUNICATION_PVT.GETSTATEORPROVINCE() SHIP_STATE_PROVINCE
, PO_COMMUNICATION_PVT.GETPOSTALCODE() SHIP_POSTAL_CODE
, PO_COMMUNICATION_PVT.GETTERRITORYSHORTNAME() SHIP_COUNTRY
, PO_COMMUNICATION_PVT.GETLOCATIONINFO(POH.BILL_TO_LOCATION_ID) BILL_TO_LOCATION_ID
, PO_COMMUNICATION_PVT.GETADDRESSLINE1() BILL_ADDRESS_LINE1
, PO_COMMUNICATION_PVT.GETADDRESSLINE2() BILL_ADDRESS_LINE2
, PO_COMMUNICATION_PVT.GETADDRESSLINE3() BILL_ADDRESS_LINE3
, PO_COMMUNICATION_PVT.GETTOWNORCITY() BILL_CITY
, PO_COMMUNICATION_PVT.GETSTATEORPROVINCE() BILL_STATE_PROVINCE
, PO_COMMUNICATION_PVT.GETPOSTALCODE() BILL_POSTAL_CODE
, PO_COMMUNICATION_PVT.GETTERRITORYSHORTNAME() BILL_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.VENDOR_SITE_ID
, POH.PO_HEADER_ID
, TO_NUMBER(NULL)
, POH.ORG_ID
, TO_NUMBER(NULL)
, NULL
FROM PO_LOOKUP_CODES PLC1
, PO_LOOKUP_CODES PLC2
, PO_HEADERS_ARCHIVE POH
, PO_HEADERS_ARCHIVE_ALL POH2
, PO_VENDORS POV
, PO_VENDOR_SITES_ALL PVS
, AP_SUPPLIER_CONTACTS PVC
, HR_EMPLOYEES HRE
, HR_EMPLOYEES HRE2
, FND_CURRENCIES_VL FCC
, AP_TERMS APT
, FND_TERRITORIES_TL FTE
WHERE NVL(POH.USER_HOLD_FLAG
, 'N') = 'N'
AND POV.VENDOR_ID = POH.VENDOR_ID
AND PVS.VENDOR_SITE_ID = POH.VENDOR_SITE_ID
AND POH.VENDOR_CONTACT_ID = PVC.VENDOR_CONTACT_ID(+)
AND HRE.EMPLOYEE_ID = POH2.AGENT_ID
AND HRE2.EMPLOYEE_ID = POH.AGENT_ID
AND POH.TERMS_ID = APT.TERM_ID(+)
AND POH.TYPE_LOOKUP_CODE IN ('STANDARD'
, 'BLANKET'
, 'CONTRACT'
, 'PLANNED')
AND FCC.CURRENCY_CODE = POH.CURRENCY_CODE
AND NVL(POH.LATEST_EXTERNAL_FLAG
, 'N') = 'Y'
AND POH2.REVISION_NUM = 0
AND POH.PO_HEADER_ID = POH2.PO_HEADER_ID
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 PVS.COUNTRY = FTE.TERRITORY_CODE (+)
AND DECODE(FTE.TERRITORY_CODE
, NULL
, '1'
, FTE.LANGUAGE) = DECODE(FTE.TERRITORY_CODE
, NULL
, '1'
, USERENV('LANG')) UNION ALL SELECT 'RELEASE' PO_TYPE
, POH.SEGMENT1
, POR.REVISION_NUM
, POR.PRINT_COUNT
, POR.CREATION_DATE
, POR.PRINTED_DATE
, POR.REVISED_DATE
, TO_DATE(NULL)
, TO_DATE(NULL)
, POH.NOTE_TO_VENDOR
, HRE.FIRST_NAME
, HRE.LAST_NAME
, POR2.AGENT_ID
, HRE2.FIRST_NAME
, HRE2.LAST_NAME
, POR.AGENT_ID
, TO_NUMBER(NULL)
, DECODE(POR.APPROVED_FLAG
, 'Y'
, 'Y'
, 'N') AMOUNT_AGREED
, DECODE(POR.CANCEL_FLAG
, 'Y'
, 'Y'
, 'I'
, 'Y'
, 'N'
, 'N'
, NULL) APPROVED_FLAG
, '' CANCEL_FLAG
, POR.ACCEPTANCE_REQUIRED_FLAG
, POR.ACCEPTANCE_DUE_DATE
, FCC.CURRENCY_CODE
, FCC.NAME
, POH.RATE
, POH.SHIP_VIA_LOOKUP_CODE SHIP_VIA
, PLC1.DISPLAYED_FIELD
, PLC2.DISPLAYED_FIELD
, APT.NAME
, POV.CUSTOMER_NUM
, POV.SEGMENT1
, POV.VENDOR_NAME
, PVS.ADDRESS_LINE1
, PVS.ADDRESS_LINE2
, PVS.ADDRESS_LINE3
, PVS.CITY
, DECODE(PVS.STATE
, NULL
, DECODE(PVS.PROVINCE
, NULL
, PVS.COUNTY
, PVS.PROVINCE)
, PVS.STATE) VENDOR_STATE
, PVS.ZIP
, FTE.TERRITORY_SHORT_NAME
, '('||PVS.AREA_CODE||') '||PVS.PHONE VENDOR_PHONE
, PVC.FIRST_NAME
, PVC.LAST_NAME
, '('||PVC.AREA_CODE||') '||PVC.PHONE VENDOR_CONTACT_PHONE
, PO_COMMUNICATION_PVT.GETLOCATIONINFO(POH.SHIP_TO_LOCATION_ID) SHIP_TO_LOCATION_ID
, PO_COMMUNICATION_PVT.GETADDRESSLINE1() SHIP_ADDRESS_LINE1
, PO_COMMUNICATION_PVT.GETADDRESSLINE2() SHIP_ADDRESS_LINE2
, PO_COMMUNICATION_PVT.GETADDRESSLINE3() SHIP_ADDRESS_LINE3
, PO_COMMUNICATION_PVT.GETTOWNORCITY() SHIP_CITY
, PO_COMMUNICATION_PVT.GETSTATEORPROVINCE() SHIP_STATE_PROVINCE
, PO_COMMUNICATION_PVT.GETPOSTALCODE() SHIP_POSTAL_CODE
, PO_COMMUNICATION_PVT.GETTERRITORYSHORTNAME() SHIP_COUNTRY
, PO_COMMUNICATION_PVT.GETLOCATIONINFO(POH.BILL_TO_LOCATION_ID) BILL_TO_LOCATION_ID
, PO_COMMUNICATION_PVT.GETADDRESSLINE1() BILL_ADDRESS_LINE1
, PO_COMMUNICATION_PVT.GETADDRESSLINE2() BILL_ADDRESS_LINE2
, PO_COMMUNICATION_PVT.GETADDRESSLINE3() BILL_ADDRESS_LINE3
, PO_COMMUNICATION_PVT.GETTOWNORCITY() BILL_CITY
, PO_COMMUNICATION_PVT.GETSTATEORPROVINCE() BILL_STATE_PROVINCE
, PO_COMMUNICATION_PVT.GETPOSTALCODE() BILL_POSTAL_CODE
, PO_COMMUNICATION_PVT.GETTERRITORYSHORTNAME() BILL_COUNTRY
, POR.ATTRIBUTE1
, POR.ATTRIBUTE2
, POR.ATTRIBUTE3
, POR.ATTRIBUTE4
, POR.ATTRIBUTE5
, POR.ATTRIBUTE6
, POR.ATTRIBUTE7
, POR.ATTRIBUTE8
, POR.ATTRIBUTE9
, POR.ATTRIBUTE10
, POR.ATTRIBUTE11
, POR.ATTRIBUTE12
, POR.ATTRIBUTE13
, POR.ATTRIBUTE14
, POR.ATTRIBUTE15
, POH.VENDOR_SITE_ID
, POH.PO_HEADER_ID
, POR.PO_RELEASE_ID
, POR.ORG_ID
, POR.RELEASE_NUM
, POR.RELEASE_TYPE
FROM PO_LOOKUP_CODES PLC1
, PO_LOOKUP_CODES PLC2
, PO_RELEASES_ARCHIVE POR
, PO_RELEASES_ARCHIVE_ALL POR2
, PO_HEADERS POH
, PO_VENDORS POV
, PO_VENDOR_SITES PVS
, AP_SUPPLIER_CONTACTS PVC
, HR_EMPLOYEES HRE
, HR_EMPLOYEES HRE2
, FND_CURRENCIES_VL FCC
, FND_TERRITORIES_TL FTE
, AP_TERMS APT
WHERE POH.TYPE_LOOKUP_CODE IN ('BLANKET'
, 'PLANNED')
AND POH.PO_HEADER_ID = POR.PO_HEADER_ID
AND POV.VENDOR_ID = POH.VENDOR_ID
AND PVS.VENDOR_SITE_ID = POH.VENDOR_SITE_ID
AND POH.VENDOR_CONTACT_ID = PVC.VENDOR_CONTACT_ID(+)
AND HRE.EMPLOYEE_ID = POR2.AGENT_ID
AND HRE2.EMPLOYEE_ID = POR.AGENT_ID
AND POH.TERMS_ID = APT.TERM_ID(+)
AND FCC.CURRENCY_CODE = POH.CURRENCY_CODE
AND NVL(POR.LATEST_EXTERNAL_FLAG
, 'N') = 'Y'
AND POR2.REVISION_NUM = 0
AND POR.PO_RELEASE_ID = POR2.PO_RELEASE_ID
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 PVS.COUNTRY = FTE.TERRITORY_CODE (+)
AND DECODE(FTE.TERRITORY_CODE
, NULL
, '1'
, FTE.LANGUAGE) = DECODE(FTE.TERRITORY_CODE
, NULL
, '1'
, USERENV('LANG'))