[Home] [Help] [Dependency Information]
Object Name: | OKX_CONFIG_DETAILS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKX.OKX_CONFIG_DETAILS_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 |
---|---|---|---|---|
CONFIG_HDR_ID | NUMBER | Yes | Configuration header identifier | |
CONFIG_REV_NBR | NUMBER | (9) | Yes | Configuration revision number |
CONFIG_ITEM_ID | NUMBER | Yes | Identifier of the confiuration item. This ID has no relation to the inventory_item_id | |
PARENT_CONFIG_ITEM_ID | NUMBER | Parent confiuration item identifier | ||
INVENTORY_ITEM_ID | NUMBER | (9) | Identifier of the inventory item associated with the configuration item (if any) | |
ORGANIZATION_ID | NUMBER | (9) | Identifier of the inventory organization associated with the configuration item (if any) | |
COMPONENT_CODE | VARCHAR2 | (1200) | Component_code from bom_explosions | |
QUANTITY | NUMBER | Configured quantity of the item | ||
UOM_CODE | VARCHAR2 | (3) | Unit of measure code for the item | |
BOM_ITEM_TYPE | NUMBER | (9) | BOM item type if applicable: 1 - model; 2 - option class; 4 - standard item. | |
PS_NODE_ID | NUMBER | (15) | Associates this record with a Model structure node ('psnode') | |
BOM_SORT_ORDER | VARCHAR2 | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT CONFIG_HDR_ID
, CONFIG_REV_NBR
, CONFIG_ITEM_ID
, PARENT_CONFIG_ITEM_ID
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, COMPONENT_CODE
, QUANTITY
, UOM_CODE
, BOM_ITEM_TYPE
, PS_NODE_ID
, BOM_SORT_ORDER
FROM APPS.OKX_CONFIG_DETAILS_V;
|
|
|