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


VIEW: APPS.ITG_CPO_PO_SCHED_V

Object Details
Object Name: ITG_CPO_PO_SCHED_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewITG.ITG_CPO_PO_SCHED_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 PO line schedule level for Cancel PO XML


[View Source]

Columns
Name Datatype Length Mandatory Comments
PO_HEADER_ID NUMBER
Yes Purchase order header Id
PO_LINE_ID NUMBER
Yes Purchase order line Id
LINE_LOCATION_ID NUMBER
Yes Line location id
PSCLINENUM NUMBER

Schedule line number
Query Text

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


SELECT PO_HEADER_ID
,      PO_LINE_ID
,      LINE_LOCATION_ID
,      PSCLINENUM
FROM APPS.ITG_CPO_PO_SCHED_V;

Dependencies

[top of page]

APPS.ITG_CPO_PO_SCHED_V references the following:

SchemaAPPS
SynonymPO_LINE_LOCATIONS_ALL

APPS.ITG_CPO_PO_SCHED_V is not referenced by any database object