[Home] [Help] [Dependency Information]
Object Name: | ASO_PVT_PENDING_ORDERS_BALI_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVENTORY_ITEM | VARCHAR2 | (40) | Concatenated segments based on the System Item key flexfield definition | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
ORDER_NUMBER | NUMBER | Yes | User-visible number of the order | |
LINE_NUMBER | NUMBER | Yes | Line sequence number within the order | |
ORDERED_DATE | DATE | Ordered Date | ||
ORG_ID | NUMBER | Organization identifier | ||
HEADER_ID | NUMBER | Yes | Order Header Identifier | |
LINE_ID | NUMBER | Yes | System Generated Line Identifier. | |
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory Item ID | |
ORGANIZATION_ID | NUMBER | Yes | ||
QUANTITY | NUMBER | Quantity Ordered | ||
UOM_CODE | VARCHAR2 | (3) | Ordered quantity Unit of measure | |
LINE_CATEGORY_CODE | VARCHAR2 | (30) | Yes | Indicates whether the line is regular or return |
CUST_PO_NUMBER | VARCHAR2 | (50) | Customer Purchase Order Number | |
CUST_ACCOUNT_ID | NUMBER | Customer to whom the item is sold to | ||
CATEGORY_ID | NUMBER | Yes | ||
CATEGORY_SET_ID | NUMBER | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM
, ITEM_DESCRIPTION
, ORDER_NUMBER
, LINE_NUMBER
, ORDERED_DATE
, ORG_ID
, HEADER_ID
, LINE_ID
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, QUANTITY
, UOM_CODE
, LINE_CATEGORY_CODE
, CUST_PO_NUMBER
, CUST_ACCOUNT_ID
, CATEGORY_ID
, CATEGORY_SET_ID
FROM APPS.ASO_PVT_PENDING_ORDERS_BALI_V;
APPS.ASO_PVT_PENDING_ORDERS_BALI_V is not referenced by any database object
|
|
|