View: ITG_UPDEL_HEADERS_V

Product:	ITG - Internet Procurement Enterprise Connector
Description:	This view is used to generate XML at header level for Update Delivery XML
Implementation/DBA Data:	APPS.ITG_UPDEL_HEADERS_V

View Text

SELECT H.SHIPMENT_HEADER_ID
, H.CREATION_DATE CREATION_DATE
, TO_CHAR(H.RECEIPT_NUM) RECEIPTID
, O.ORGANIZATION_ID SITELEVEL_1
, P.FULL_NAME EMPLOYEEID
, P.EMAIL_ADDRESS EMPLOYEE_EMAIL
, H.COMMENTS NOTES
, O.OPERATING_UNIT SITELEVEL_2
, H.BILL_OF_LADING BILLOLADING
, H.SHIPPED_DATE DATETIME_SHIP
, H.RECEIPT_SOURCE_CODE UA_RCPTSOURCE
, H.SHIPMENT_NUM UA_SHIPMENTNO
, H.PACKING_SLIP UA_PACKINGSLIP
, H.FREIGHT_CARRIER_CODE UA_CARRIER
, V.SEGMENT1 UA_SUPPLIER
, V.VENDOR_NAME VENDOR_NAME
, H.WAYBILL_AIRBILL_NUM UA_WAYBILL
, H.ATTRIBUTE1 UA_ATTRIBUTE1
, H.ATTRIBUTE2 UA_ATTRIBUTE2
, H.ATTRIBUTE3 UA_ATTRIBUTE3
, H.ATTRIBUTE4 UA_ATTRIBUTE4
, H.ATTRIBUTE5 UA_ATTRIBUTE5
, H.ATTRIBUTE6 UA_ATTRIBUTE6
, H.ATTRIBUTE7 UA_ATTRIBUTE7
, H.ATTRIBUTE8 UA_ATTRIBUTE8
, H.ATTRIBUTE9 UA_ATTRIBUTE9
, H.ATTRIBUTE10 UA_ATTRIBUTE10
, H.ATTRIBUTE11 UA_ATTRIBUTE11
, H.ATTRIBUTE12 UA_ATTRIBUTE12
, H.ATTRIBUTE13 UA_ATTRIBUTE13
, H.ATTRIBUTE14 UA_ATTRIBUTE14
, H.ATTRIBUTE15 UA_ATTRIBUTE15
, HOUV.NAME HR_ORGANIZATION_NAME
, HOUV.ADDRESS_LINE_1 HR_ADDRESS_LINE_1
, HOUV.ADDRESS_LINE_2 HR_ADDRESS_LINE_2
, HOUV.ADDRESS_LINE_3 HR_ADDRESS_LINE_3
, HOUV.TOWN_OR_CITY HR_CITY
, HOUV.COUNTRY HR_COUNTRY
, HOUV.POSTAL_CODE HR_POSTAL_CODE
, PVC.FIRST_NAME || ' ' || PVC.MIDDLE_NAME || ' ' || PVC.LAST_NAME PO_CONTACT_NAME
, PVC.AREA_CODE || ' ' || PVC.PHONE PO_PHONE
, PVSA.EMAIL_ADDRESS PO_EMAIL_ADDRESS
, PVSA.ADDRESS_LINE1 PO_ADDRESS_LINE_1
, PVSA.ADDRESS_LINE2 PO_ADDRESS_LINE_2
, PVSA.ADDRESS_LINE3 PO_ADDRESS_LINE_3
, PVSA.CITY PO_CITY
, PVSA.COUNTRY PO_COUNTRY
, PVSA.ZIP PO_ZIP
, PVSA.ECE_TP_LOCATION_CODE PO_EDI_LOCATION_CODE
, H.VENDOR_ID
, H.VENDOR_SITE_ID
FROM PER_PEOPLE_F P
, ORG_ORGANIZATION_DEFINITIONS O
, PO_VENDORS V
, RCV_SHIPMENT_HEADERS H
, HR_ORGANIZATION_UNITS_V HOUV
, PO_VENDOR_SITES_ALL PVSA
, PO_VENDOR_CONTACTS PVC
WHERE NVL(H.SHIPPED_DATE
, H.LAST_UPDATE_DATE) BETWEEN NVL(P.EFFECTIVE_START_DATE
, NVL(H.SHIPPED_DATE
, H.LAST_UPDATE_DATE))
AND NVL(P.EFFECTIVE_END_DATE
, NVL(H.SHIPPED_DATE
, H.LAST_UPDATE_DATE))
AND P.PERSON_ID (+) = H.EMPLOYEE_ID
AND O.ORGANIZATION_ID (+) =NVL( H.ORGANIZATION_ID
, H.SHIP_TO_ORG_ID)
AND V.VENDOR_ID (+) = H.VENDOR_ID
AND H.ORGANIZATION_ID = HOUV.ORGANIZATION_ID(+)
AND P.VENDOR_ID = PVSA.VENDOR_ID(+)
AND PVSA.VENDOR_SITE_ID = PVC.VENDOR_SITE_ID(+)

Columns