View: PO_HEADERS_CHANGE_PRINT

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.PO_HEADERS_CHANGE_PRINT

View Text

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
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
, PO_VENDOR_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
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
, PO_VENDOR_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'))

Columns