VIEW: APPS.ITG_UPDEL_HEADERS_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)