[Home] [Help] [Dependency Information]
Object Name: | ITG_SP_REL_LINE_SCHED_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ITG.ITG_SP_REL_LINE_SCHED_V |
Subobject Name: | |
Status: | VALID |
This view is used to generate XML at po release line schedules level
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) |
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;
APPS.ITG_SP_REL_LINE_SCHED_V is not referenced by any database object
|
|
|