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


VIEW: APPS.ITG_SP_REL_LINE_SCHED_V

Object Details
Object Name: ITG_SP_REL_LINE_SCHED_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewITG.ITG_SP_REL_LINE_SCHED_V
Subobject Name:
Status: VALID


This view is used to generate XML at po release line schedules level


[View Source]

Columns
Name Datatype Length Mandatory Comments
PO_HEADER_ID NUMBER
Yes
PO_RELEASE_ID NUMBER

PO_LINE_ID NUMBER
Yes
LINE_LOCATION_ID NUMBER
Yes
DATETIME_NEEDDELV DATE

ORDERED_QUANTITY NUMBER

ORDERED_UOM VARCHAR2 (3) Yes
SHIPMENT_NUM NUMBER

UA_SCHEDLID VARCHAR2 (40)
UA_SCHED_ATTR1 VARCHAR2 (150)
UA_SCHED_ATTR2 VARCHAR2 (150)
UA_SCHED_ATTR3 VARCHAR2 (150)
UA_SCHED_ATTR4 VARCHAR2 (150)
UA_SCHED_ATTR5 VARCHAR2 (150)
UA_SCHED_ATTR6 VARCHAR2 (150)
UA_SCHED_ATTR7 VARCHAR2 (150)
UA_SCHED_ATTR8 VARCHAR2 (150)
UA_SCHED_ATTR9 VARCHAR2 (150)
UA_SCHED_ATTR10 VARCHAR2 (150)
UA_SCHED_ATTR11 VARCHAR2 (150)
UA_SCHED_ATTR12 VARCHAR2 (150)
UA_SCHED_ATTR13 VARCHAR2 (150)
UA_SCHED_ATTR14 VARCHAR2 (150)
UA_SCHED_ATTR15 VARCHAR2 (150)
Query Text

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


SELECT PO_HEADER_ID
,      PO_RELEASE_ID
,      PO_LINE_ID
,      LINE_LOCATION_ID
,      DATETIME_NEEDDELV
,      ORDERED_QUANTITY
,      ORDERED_UOM
,      SHIPMENT_NUM
,      UA_SCHEDLID
,      UA_SCHED_ATTR1
,      UA_SCHED_ATTR2
,      UA_SCHED_ATTR3
,      UA_SCHED_ATTR4
,      UA_SCHED_ATTR5
,      UA_SCHED_ATTR6
,      UA_SCHED_ATTR7
,      UA_SCHED_ATTR8
,      UA_SCHED_ATTR9
,      UA_SCHED_ATTR10
,      UA_SCHED_ATTR11
,      UA_SCHED_ATTR12
,      UA_SCHED_ATTR13
,      UA_SCHED_ATTR14
,      UA_SCHED_ATTR15
FROM APPS.ITG_SP_REL_LINE_SCHED_V;

Dependencies

[top of page]

APPS.ITG_SP_REL_LINE_SCHED_V references the following:

SchemaAPPS
SynonymMTL_UNITS_OF_MEASURE
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL

APPS.ITG_SP_REL_LINE_SCHED_V is not referenced by any database object