[Home] [Help] [Dependency Information]
Object Name: | ASO_I_RELATED_ITEMS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ASO.ASO_I_RELATED_ITEMS_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 | Product Identifier | ||
RELATED_ITEM_ID | NUMBER | Related Product Identifier | ||
RELATIONSHIP_TYPE_ID | NUMBER | Relationship Type Identifier | ||
RELATIONSHIP_TYPE | VARCHAR2 | (80) | Yes | Relationship Type |
RECIPROCAL_FLAG | VARCHAR2 | (1) | Flag to indicate whether relationship is reciprocal | |
RELATED_ITEM_DESCRIPTION | VARCHAR2 | (240) | Description of the Related Product | |
RELATED_ITEM | VARCHAR2 | (40) | Name of the Related Product | |
PADDED_CONCATENATED_SEGMENTS | VARCHAR2 | (40) | ||
UOM | VARCHAR2 | (3) | UOM of Related Product | |
UNIT_PRICE | NUMBER | Unit Price of Related Product |
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_DESCRIPTION
, RELATED_ITEM
, PADDED_CONCATENATED_SEGMENTS
, UOM
, UNIT_PRICE
FROM APPS.ASO_I_RELATED_ITEMS_V;
APPS.ASO_I_RELATED_ITEMS_V is not referenced by any database object
|
|
|