eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.ITG_UPDEL_HEADERS_V

Object Details

Object Name:	ITG_UPDEL_HEADERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ITG.ITG_UPDEL_HEADERS_V
Subobject Name:
Status:	VALID

This view is used to generate XML at header level for Update Delivery XML

[View Source]

Columns

Name	Datatype	Length	Mandatory
SHIPMENT_HEADER_ID	NUMBER		Yes
CREATION_DATE	DATE		Yes
RECEIPTID	VARCHAR2	(30)
SITELEVEL_1	NUMBER	(15)
EMPLOYEEID	VARCHAR2	(240)
EMPLOYEE_EMAIL	VARCHAR2	(240)
NOTES	VARCHAR2	(4000)
SITELEVEL_2	NUMBER
BILLOLADING	VARCHAR2	(25)
DATETIME_SHIP	DATE
UA_RCPTSOURCE	VARCHAR2	(25)	Yes
UA_SHIPMENTNO	VARCHAR2	(30)
UA_PACKINGSLIP	VARCHAR2	(25)
UA_CARRIER	VARCHAR2	(25)
UA_SUPPLIER	VARCHAR2	(30)
VENDOR_NAME	VARCHAR2	(240)
UA_WAYBILL	VARCHAR2	(30)
UA_ATTRIBUTE1	VARCHAR2	(150)
UA_ATTRIBUTE2	VARCHAR2	(150)
UA_ATTRIBUTE3	VARCHAR2	(150)
UA_ATTRIBUTE4	VARCHAR2	(150)
UA_ATTRIBUTE5	VARCHAR2	(150)
UA_ATTRIBUTE6	VARCHAR2	(150)
UA_ATTRIBUTE7	VARCHAR2	(150)
UA_ATTRIBUTE8	VARCHAR2	(150)
UA_ATTRIBUTE9	VARCHAR2	(150)
UA_ATTRIBUTE10	VARCHAR2	(150)
UA_ATTRIBUTE11	VARCHAR2	(150)
UA_ATTRIBUTE12	VARCHAR2	(150)
UA_ATTRIBUTE13	VARCHAR2	(150)
UA_ATTRIBUTE14	VARCHAR2	(150)
UA_ATTRIBUTE15	VARCHAR2	(150)
HR_ORGANIZATION_NAME	VARCHAR2	(240)
HR_ADDRESS_LINE_1	VARCHAR2	(240)
HR_ADDRESS_LINE_2	VARCHAR2	(240)
HR_ADDRESS_LINE_3	VARCHAR2	(240)
HR_CITY	VARCHAR2	(30)
HR_COUNTRY	VARCHAR2	(60)
HR_POSTAL_CODE	VARCHAR2	(30)
PO_CONTACT_NAME	VARCHAR2	(47)
PO_PHONE	VARCHAR2	(51)
PO_EMAIL_ADDRESS	VARCHAR2	(2000)
PO_ADDRESS_LINE_1	VARCHAR2	(240)
PO_ADDRESS_LINE_2	VARCHAR2	(240)
PO_ADDRESS_LINE_3	VARCHAR2	(240)
PO_CITY	VARCHAR2	(60)
PO_COUNTRY	VARCHAR2	(25)
PO_ZIP	VARCHAR2	(20)
PO_EDI_LOCATION_CODE	VARCHAR2	(60)
VENDOR_ID	NUMBER
VENDOR_SITE_ID	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SHIPMENT_HEADER_ID
,      CREATION_DATE
,      RECEIPTID
,      SITELEVEL_1
,      EMPLOYEEID
,      EMPLOYEE_EMAIL
,      NOTES
,      SITELEVEL_2
,      BILLOLADING
,      DATETIME_SHIP
,      UA_RCPTSOURCE
,      UA_SHIPMENTNO
,      UA_PACKINGSLIP
,      UA_CARRIER
,      UA_SUPPLIER
,      VENDOR_NAME
,      UA_WAYBILL
,      UA_ATTRIBUTE1
,      UA_ATTRIBUTE2
,      UA_ATTRIBUTE3
,      UA_ATTRIBUTE4
,      UA_ATTRIBUTE5
,      UA_ATTRIBUTE6
,      UA_ATTRIBUTE7
,      UA_ATTRIBUTE8
,      UA_ATTRIBUTE9
,      UA_ATTRIBUTE10
,      UA_ATTRIBUTE11
,      UA_ATTRIBUTE12
,      UA_ATTRIBUTE13
,      UA_ATTRIBUTE14
,      UA_ATTRIBUTE15
,      HR_ORGANIZATION_NAME
,      HR_ADDRESS_LINE_1
,      HR_ADDRESS_LINE_2
,      HR_ADDRESS_LINE_3
,      HR_CITY
,      HR_COUNTRY
,      HR_POSTAL_CODE
,      PO_CONTACT_NAME
,      PO_PHONE
,      PO_EMAIL_ADDRESS
,      PO_ADDRESS_LINE_1
,      PO_ADDRESS_LINE_2
,      PO_ADDRESS_LINE_3
,      PO_CITY
,      PO_COUNTRY
,      PO_ZIP
,      PO_EDI_LOCATION_CODE
,      VENDOR_ID
,      VENDOR_SITE_ID
FROM APPS.ITG_UPDEL_HEADERS_V;

Dependencies

[top of page]

APPS.ITG_UPDEL_HEADERS_V references the following:

APPS: FND_GLOBAL - show dependent code; HR_API - show dependent code; HR_GENERAL - show dependent code; HR_ORGANIZATION_UNITS_V; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; ORG_ORGANIZATION_DEFINITIONS; PER_PEOPLE_F; PO_VENDORS; PO_VENDOR_CONTACTS; PO_VENDOR_SITES_ALL; RCV_SHIPMENT_HEADERS

APPS.ITG_UPDEL_HEADERS_V is not referenced by any database object