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_LINES_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
SHIPMENT_HEADER_ID	NUMBER
LINE_NUM	NUMBER		Yes
TRANSACTION_ID	NUMBER
REQUEST_ID	NUMBER
QUANT_RECV_QUANTITY	NUMBER
QUANT_RECV_UOMCODE	VARCHAR2	(3)	Yes
TRANSACTION_DATE_DELIVACT	DATE
ITEM	VARCHAR2	(4000)
RECLINENUM	VARCHAR2	(40)
DECSRIPTN	VARCHAR2	(240)
ITEMRV	VARCHAR2	(3)
ITEMX	VARCHAR2	(25)
LINE_NOTES	VARCHAR2	(4000)
POID	VARCHAR2	(20)
POLINENUM	VARCHAR2	(40)
PORELEASE	VARCHAR2	(40)
PSCLINENUM	VARCHAR2	(40)
RECEPTDISP	VARCHAR2	(25)
LINE_UA_ORG	VARCHAR2	(240)
LINE_UA_SUBINV	VARCHAR2	(10)
LINE_UA_LOCATOR	VARCHAR2	(4000)
LINE_UA_DELIVERTO	VARCHAR2	(240)
LINE_UA_DELVLOC	VARCHAR2	(60)
LINE_UA_RCVTRANID	NUMBER
LINE_UA_DESTTYPE	VARCHAR2	(25)
LINE_UA_INSPSTS	VARCHAR2	(25)
LINE_UA_PACKINGSLIP	VARCHAR2	(25)
LINE_UA_RMA	VARCHAR2	(30)
LINE_UA_XREF	VARCHAR2	(4000)
LINE_UA_SHIPTOLOC	VARCHAR2	(60)
LINE_UA_REASONCODE	VARCHAR2	(30)
LINE_UA_ATTRIBUTE1	VARCHAR2	(150)
LINE_UA_ATTRIBUTE2	VARCHAR2	(150)
LINE_UA_ATTRIBUTE3	VARCHAR2	(150)
LINE_UA_ATTRIBUTE4	VARCHAR2	(150)
LINE_UA_ATTRIBUTE5	VARCHAR2	(150)
LINE_UA_ATTRIBUTE6	VARCHAR2	(150)
LINE_UA_ATTRIBUTE7	VARCHAR2	(150)
LINE_UA_ATTRIBUTE8	VARCHAR2	(150)
LINE_UA_ATTRIBUTE9	VARCHAR2	(150)
LINE_UA_ATTRIBUTE10	VARCHAR2	(150)
LINE_UA_ATTRIBUTE11	VARCHAR2	(150)
LINE_UA_ATTRIBUTE12	VARCHAR2	(150)
LINE_UA_ATTRIBUTE13	VARCHAR2	(150)
LINE_UA_ATTRIBUTE14	VARCHAR2	(150)
LINE_UA_ATTRIBUTE15	VARCHAR2	(150)
TXN_UOM	VARCHAR2	(25)
SHIP_VIA_LOOKUP_CODE	VARCHAR2	(25)
SEGMENT1	VARCHAR2	(40)

Query Text

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


SELECT SHIPMENT_HEADER_ID
,      LINE_NUM
,      TRANSACTION_ID
,      REQUEST_ID
,      QUANT_RECV_QUANTITY
,      QUANT_RECV_UOMCODE
,      TRANSACTION_DATE_DELIVACT
,      ITEM
,      RECLINENUM
,      DECSRIPTN
,      ITEMRV
,      ITEMX
,      LINE_NOTES
,      POID
,      POLINENUM
,      PORELEASE
,      PSCLINENUM
,      RECEPTDISP
,      LINE_UA_ORG
,      LINE_UA_SUBINV
,      LINE_UA_LOCATOR
,      LINE_UA_DELIVERTO
,      LINE_UA_DELVLOC
,      LINE_UA_RCVTRANID
,      LINE_UA_DESTTYPE
,      LINE_UA_INSPSTS
,      LINE_UA_PACKINGSLIP
,      LINE_UA_RMA
,      LINE_UA_XREF
,      LINE_UA_SHIPTOLOC
,      LINE_UA_REASONCODE
,      LINE_UA_ATTRIBUTE1
,      LINE_UA_ATTRIBUTE2
,      LINE_UA_ATTRIBUTE3
,      LINE_UA_ATTRIBUTE4
,      LINE_UA_ATTRIBUTE5
,      LINE_UA_ATTRIBUTE6
,      LINE_UA_ATTRIBUTE7
,      LINE_UA_ATTRIBUTE8
,      LINE_UA_ATTRIBUTE9
,      LINE_UA_ATTRIBUTE10
,      LINE_UA_ATTRIBUTE11
,      LINE_UA_ATTRIBUTE12
,      LINE_UA_ATTRIBUTE13
,      LINE_UA_ATTRIBUTE14
,      LINE_UA_ATTRIBUTE15
,      TXN_UOM
,      SHIP_VIA_LOOKUP_CODE
,      SEGMENT1
FROM APPS.ITG_UPDEL_LINES_V;

Dependencies

[top of page]

APPS.ITG_UPDEL_LINES_V references the following:

APPS: HR_GENERAL - show dependent code; HR_LOCATIONS_ALL_TL; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; ITG_X_UTILS - show dependent code; MTL_ITEM_LOCATIONS; MTL_SYSTEM_ITEMS; MTL_TRANSACTION_REASONS; MTL_UNITS_OF_MEASURE; ORG_ORGANIZATION_DEFINITIONS; PER_PEOPLE_F; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; PO_RELEASES_ALL; RCV_SHIPMENT_HEADERS; RCV_SHIPMENT_LINES; RCV_TRANSACTIONS

APPS.ITG_UPDEL_LINES_V is not referenced by any database object