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: ViewITG.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 Comments
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:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_LOCATIONS_ALL_TL
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
PL/SQL PackageITG_X_UTILS - show dependent code
SynonymMTL_ITEM_LOCATIONS
SynonymMTL_SYSTEM_ITEMS
SynonymMTL_TRANSACTION_REASONS
SynonymMTL_UNITS_OF_MEASURE
ViewORG_ORGANIZATION_DEFINITIONS
ViewPER_PEOPLE_F
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_RELEASES_ALL
SynonymRCV_SHIPMENT_HEADERS
SynonymRCV_SHIPMENT_LINES
SynonymRCV_TRANSACTIONS

APPS.ITG_UPDEL_LINES_V is not referenced by any database object