[Home] [Help] [Dependency Information]
Object Name: | ASO_PVT_RELATED_ITEMS_BALI_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ASO.ASO_PVT_RELATED_ITEMS_BALI_V |
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 |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | Organization identifier | ||
INVENTORY_ITEM_ID | NUMBER | Inventory item identifier | ||
RELATED_ITEM_ID | NUMBER | Related inventory item identifier | ||
RELATIONSHIP_TYPE_ID | NUMBER | Relationship type identifier | ||
RELATIONSHIP_TYPE | VARCHAR2 | (80) | Yes | Lookup meaning |
RECIPROCAL_FLAG | VARCHAR2 | (1) | Flag to indicate whether relationship is reciprocal | |
RELATED_ITEM | VARCHAR2 | (40) | Concatenated segments based on the System Item key flexfield definition | |
RELATED_ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
RELATED_UOM_CODE | VARCHAR2 | (3) | ||
RELATED_UNIT_PRICE | NUMBER | |||
REQUEST_DATE | DATE | |||
SHIP_DATE | VARCHAR2 | (0) | ||
AVAILABLE_QUANTITY | VARCHAR2 | (0) | ||
REQUEST_DATE_QUANTITY | VARCHAR2 | (0) | ||
BOM_ITEM_TYPE | NUMBER | Yes | ||
SERVICE_ITEM_FLAG | VARCHAR2 | (1) | Yes | |
VENDOR_WARRANTY_FLAG | VARCHAR2 | (1) | Yes | |
CUSTOMER_ORDER_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
RETURNABLE_FLAG | VARCHAR2 | (1) | ||
PADDED_CONCATENATED_SEGMENTS | VARCHAR2 | (40) | ||
ITEM_TYPE_CODE | VARCHAR2 | (3) | ||
SERVICE_DURATION | NUMBER | |||
SERVICE_PERIOD | VARCHAR2 | (10) |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, INVENTORY_ITEM_ID
, RELATED_ITEM_ID
, RELATIONSHIP_TYPE_ID
, RELATIONSHIP_TYPE
, RECIPROCAL_FLAG
, RELATED_ITEM
, RELATED_ITEM_DESCRIPTION
, RELATED_UOM_CODE
, RELATED_UNIT_PRICE
, REQUEST_DATE
, SHIP_DATE
, AVAILABLE_QUANTITY
, REQUEST_DATE_QUANTITY
, BOM_ITEM_TYPE
, SERVICE_ITEM_FLAG
, VENDOR_WARRANTY_FLAG
, CUSTOMER_ORDER_ENABLED_FLAG
, RETURNABLE_FLAG
, PADDED_CONCATENATED_SEGMENTS
, ITEM_TYPE_CODE
, SERVICE_DURATION
, SERVICE_PERIOD
FROM APPS.ASO_PVT_RELATED_ITEMS_BALI_V;
APPS.ASO_PVT_RELATED_ITEMS_BALI_V is not referenced by any database object
|
|
|