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

VIEW: APPS.OKX_CONFIG_ITEMS_V

Object Details
Object Name: OKX_CONFIG_ITEMS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKX.OKX_CONFIG_ITEMS_V
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
CONFIG_HDR_ID NUMBER
Yes Configuration header identifier
CONFIG_REV_NBR NUMBER (9) Yes Configuration revision number
CONFIG_ITEM_ID NUMBER
Yes Unique identifier of configuration item
UOM_CODE VARCHAR2 (3)
Code indicating the unit of measure for Quantity. Usually "Ea" indicating 'each'.
PS_NODE_ID NUMBER (15)
Project structure node identifier
VALUE_TYPE_CODE NUMBER
Yes Value type code: EMPTY = 0; TEXT = 2; NUMERIC = 3; COMPONENT = 4;
ROOT_BOM_CONFIG_ITEM_ID NUMBER (15)
Configuration item identifier of root bom item
SEQUENCE_NBR NUMBER

Sequence number of item as a child of its parent
ITEM_VAL VARCHAR2 (4000)
Item value
INSTANCE_NBR NUMBER

Component instance number
PARENT_CONFIG_ITEM_ID NUMBER

Configuration item identifier of the parent item
COMPONENT_CODE VARCHAR2 (1200)
Alternative configuration item identifier. The component code is the concatenation of the inventory item ids of all the parent items part of the configuration, completed by the current inventory item id, in the following format: --- ....-
INVENTORY_ITEM_ID NUMBER (9)
Inventory item identifier of the configuration item
ORGANIZATION_ID NUMBER (9)
Organization identifier
COMPONENT_SEQUENCE_ID NUMBER (15)
Sequence identifier of the component instance
DELETED_FLAG VARCHAR2 (1) Yes Flag indicating if record was deleted by the user. If deleted_flag=1 the record will be purged.
EFF_FROM DATE

Not currently used
EFF_TO DATE

Not currently used
SECURITY_MASK VARCHAR2 (40)
Not currently used
EFF_MASK VARCHAR2 (40)
Not currently used
CHECKOUT_USER VARCHAR2 (40)
Not currently used
USER_STR01 VARCHAR2 (255)
Standard extension field (string)
USER_STR02 VARCHAR2 (255)
Standard extension field (string)
USER_STR03 VARCHAR2 (255)
Standard extension field (string)
USER_STR04 VARCHAR2 (255)
Standard extension field (string)
USER_NUM01 NUMBER

Standard extension field (numeric)
USER_NUM02 NUMBER

Standard extension field (numeric)
USER_NUM03 NUMBER

Standard extension field (numeric)
USER_NUM04 NUMBER

Standard extension field (numeric)
Query Text

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


SELECT CONFIG_HDR_ID
,      CONFIG_REV_NBR
,      CONFIG_ITEM_ID
,      UOM_CODE
,      PS_NODE_ID
,      VALUE_TYPE_CODE
,      ROOT_BOM_CONFIG_ITEM_ID
,      SEQUENCE_NBR
,      ITEM_VAL
,      INSTANCE_NBR
,      PARENT_CONFIG_ITEM_ID
,      COMPONENT_CODE
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      COMPONENT_SEQUENCE_ID
,      DELETED_FLAG
,      EFF_FROM
,      EFF_TO
,      SECURITY_MASK
,      EFF_MASK
,      CHECKOUT_USER
,      USER_STR01
,      USER_STR02
,      USER_STR03
,      USER_STR04
,      USER_NUM01
,      USER_NUM02
,      USER_NUM03
,      USER_NUM04
FROM APPS.OKX_CONFIG_ITEMS_V;

Dependencies

[top of page]

APPS.OKX_CONFIG_ITEMS_V references the following:

SchemaAPPS
SynonymCZ_CONFIG_ITEMS
APPS.OKX_CONFIG_ITEMS_V is referenced by following:

SchemaAPPS
Package BodyOKC_OC_INT_KTQ_PVT - show dependent code