eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.ASO_PVT_PENDING_ORDERS_BALI_V

Object Details

Object Name:	ASO_PVT_PENDING_ORDERS_BALI_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

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

Query Text

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;

Dependencies

[top of page]

APPS.ASO_PVT_PENDING_ORDERS_BALI_V references the following:

APPS: MTL_ITEM_CATEGORIES; MTL_SYSTEM_ITEMS_VL; OE_ORDER_HEADERS; OE_ORDER_LINES_ALL; OE_PROFILE - show dependent code

APPS.ASO_PVT_PENDING_ORDERS_BALI_V is not referenced by any database object