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

VIEW: APPS.POS_CHV_ITEM_ORDERS_V

Object Details
Object Name: POS_CHV_ITEM_ORDERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.POS_CHV_ITEM_ORDERS_V
ViewPOS.POS_CHV_ITEM_ORDERS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


POS_CHV_ITEM_ORDERS_V is a view used to select the item orders details info


[View Source]

Columns
Name Datatype Length Mandatory Comments
SCHEDULE_ID NUMBER

Schedule Identifier
SCHEDULE_ITEM_ID NUMBER

Schedule Item Identifier
SCHEDULE_ORDER_ID NUMBER

Schedule Order Identifier
SUPPLY_DOCUMENT_TYPE_CODE VARCHAR2 (25)
Supply Document Type Code
SUPPLY_DOCUMENT_TYPE VARCHAR2 (80)
Supply Document Type
ORDER_QUANTITY NUMBER

Order Quantity
PURCHASING_UNIT_OF_MEASURE VARCHAR2 (25)
Purchasing Unit of Measure
PRIMARY_UNIT_OF_MEASURE VARCHAR2 (25)
Primary Unit of Measure
DUE_DATE DATE

Due Date
DOCUMENT_HEADER_ID NUMBER

Document Header Identifier
DOCUMENT_NUMBER VARCHAR2 (61)
Document Number
DOCUMENT_STATUS VARCHAR2 (80)
Document Status
DOCUMENT_REVISION NUMBER

Document Revision
DOCUMENT_LINE_ID NUMBER

Document Line Identifier
DOCUMENT_LINE_NUMBER NUMBER

Document Line Number
DOCUMENT_SHIPMENT_ID NUMBER

Document Shipment Identifier
DOCUMENT_SHIPMENT_NUMBER NUMBER

Document Shipment Number
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute Category
ATTRIBUTE1 VARCHAR2 (150)
flexfield 1
ATTRIBUTE2 VARCHAR2 (150)
flexfield 2
ATTRIBUTE3 VARCHAR2 (150)
flexfield 3
ATTRIBUTE4 VARCHAR2 (150)
flexfield 4
ATTRIBUTE5 VARCHAR2 (150)
flexfield 5
ATTRIBUTE6 VARCHAR2 (150)
flexfield 6
ATTRIBUTE7 VARCHAR2 (150)
flexfield 7
ATTRIBUTE8 VARCHAR2 (150)
flexfield 8
ATTRIBUTE9 VARCHAR2 (150)
flexfield 9
ATTRIBUTE10 VARCHAR2 (150)
flexfield 10
ATTRIBUTE11 VARCHAR2 (150)
flexfield 11
ATTRIBUTE12 VARCHAR2 (150)
flexfield 12
ATTRIBUTE13 VARCHAR2 (150)
flexfield 13
ATTRIBUTE14 VARCHAR2 (150)
flexfield 14
ATTRIBUTE15 VARCHAR2 (150)
flexfield 15
LAST_UPDATE_DATE DATE

Last Update Date
LAST_UPDATED_BY NUMBER

Last Updated By
CREATION_DATE DATE

Creation Date
CREATED_BY NUMBER

Created By
LAST_UPDATE_LOGIN NUMBER

Last Update Login
REQUEST_ID NUMBER

Request Identifier
PROGRAM_APPLICATION_ID NUMBER

Program Application Identifier
PROGRAM_UPDATE_DATE DATE

Program Update Date
Query Text

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


SELECT SCHEDULE_ID
,      SCHEDULE_ITEM_ID
,      SCHEDULE_ORDER_ID
,      SUPPLY_DOCUMENT_TYPE_CODE
,      SUPPLY_DOCUMENT_TYPE
,      ORDER_QUANTITY
,      PURCHASING_UNIT_OF_MEASURE
,      PRIMARY_UNIT_OF_MEASURE
,      DUE_DATE
,      DOCUMENT_HEADER_ID
,      DOCUMENT_NUMBER
,      DOCUMENT_STATUS
,      DOCUMENT_REVISION
,      DOCUMENT_LINE_ID
,      DOCUMENT_LINE_NUMBER
,      DOCUMENT_SHIPMENT_ID
,      DOCUMENT_SHIPMENT_NUMBER
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
FROM APPS.POS_CHV_ITEM_ORDERS_V;

Dependencies

[top of page]

APPS.POS_CHV_ITEM_ORDERS_V references the following:

SchemaAPPS
SynonymCHV_ITEM_ORDERS
SynonymCHV_SCHEDULE_ITEMS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymPO_DOCUMENT_TYPES
SynonymPO_DOCUMENT_TYPES_ALL_TL
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
ViewPO_LOOKUP_CODES
SynonymPO_RELEASES_ALL
SynonymPO_REQUISITION_HEADERS
SynonymPO_REQUISITION_LINES

APPS.POS_CHV_ITEM_ORDERS_V is not referenced by any database object