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


VIEW: APPS.ITG_SP_PO_LINE_SCHED_V

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


This view is used to generate XML for Sync PO at line schedule level


[View Source]

Columns
Name Datatype Length Mandatory Comments
PO_HEADER_ID NUMBER
Yes
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)
TO_PO_INTERNAL VARCHAR2 (0)
TO_MISC VARCHAR2 (0)
TO_APPROVER VARCHAR2 (0)
TO_BUYER VARCHAR2 (0)
TO_PAYABLES VARCHAR2 (0)
TO_RECEIVER VARCHAR2 (0)
TO_SUPPLIER VARCHAR2 (0)
DROP_SHIP_FLAG VARCHAR2 (1)
Query Text

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


SELECT PO_HEADER_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
,      TO_PO_INTERNAL
,      TO_MISC
,      TO_APPROVER
,      TO_BUYER
,      TO_PAYABLES
,      TO_RECEIVER
,      TO_SUPPLIER
,      DROP_SHIP_FLAG
FROM APPS.ITG_SP_PO_LINE_SCHED_V;

Dependencies

[top of page]

APPS.ITG_SP_PO_LINE_SCHED_V references the following:

SchemaAPPS
SynonymMTL_UNITS_OF_MEASURE
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL

APPS.ITG_SP_PO_LINE_SCHED_V is not referenced by any database object