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

VIEW: APPS.ASO_PVT_INSTALL_BASE_BALI_V

Object Details
Object Name: ASO_PVT_INSTALL_BASE_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
INSTANCE_ID NUMBER
Yes
INSTANCE_NUMBER VARCHAR2 (30) Yes
SERIAL_NUMBER VARCHAR2 (30)
QUANTITY NUMBER
Yes
UOM_CODE VARCHAR2 (3) Yes
SYSTEM_ID NUMBER

SYSTEM_NAME VARCHAR2 (50)
INVENTORY_ITEM_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
INVENTORY_ITEM VARCHAR2 (40)
ITEM_DESCRIPTION VARCHAR2 (240)
BASE_ITEM_ID NUMBER

BOM_ITEM_TYPE NUMBER
Yes
SERVICEABLE_PRODUCT_FLAG VARCHAR2 (1) Yes
CUST_ACCOUNT_ID NUMBER

ORDER_NUMBER NUMBER

ORDERED_DATE DATE

INSTALL_LOCATION_TYPE_CODE VARCHAR2 (30)
INSTALL_LOCATION_ID NUMBER

Query Text

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


SELECT INSTANCE_ID
,      INSTANCE_NUMBER
,      SERIAL_NUMBER
,      QUANTITY
,      UOM_CODE
,      SYSTEM_ID
,      SYSTEM_NAME
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM
,      ITEM_DESCRIPTION
,      BASE_ITEM_ID
,      BOM_ITEM_TYPE
,      SERVICEABLE_PRODUCT_FLAG
,      CUST_ACCOUNT_ID
,      ORDER_NUMBER
,      ORDERED_DATE
,      INSTALL_LOCATION_TYPE_CODE
,      INSTALL_LOCATION_ID
FROM APPS.ASO_PVT_INSTALL_BASE_BALI_V;

Dependencies

[top of page]

APPS.ASO_PVT_INSTALL_BASE_BALI_V references the following:

SchemaAPPS
SynonymCSI_ITEM_INSTANCES
ViewCSI_SYSTEMS_VL
ViewMTL_SYSTEM_ITEMS_VL
SynonymOE_ORDER_HEADERS
SynonymOE_ORDER_LINES_ALL

APPS.ASO_PVT_INSTALL_BASE_BALI_V is not referenced by any database object