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

TABLE: CZ.CZ_CONFIG_INPUTS

Object Details
Object Name: CZ_CONFIG_INPUTS
Object Type: TABLE
Owner: CZ
FND Design Data: TableCZ.CZ_CONFIG_INPUTS
Subobject Name:
Status: VALID


CZ_CONFIG_INPUTS stores information about user inputs while creating configuration. This table is a child of CZ_CONFIG_HDRS table. It has one row for each user input.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: CZ_CONFIG_INPUTS_PK
  1. ColumnCONFIG_HDR_ID
  2. ColumnCONFIG_INPUT_ID
  3. ColumnCONFIG_REV_NBR
Indexes
Index Type Uniqueness Tablespace Column
CZ_CONFIG_INPUTS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONFIG_HDR_ID
ColumnCONFIG_INPUT_ID
ColumnCONFIG_REV_NBR
CZ_CONFIG_INPUTS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARENT_INPUT_ID
ColumnCONFIG_HDR_ID
ColumnCONFIG_REV_NBR
CZ_CONFIG_INPUTS_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONFIG_HDR_ID
ColumnCONFIG_REV_NBR
ColumnCONFIG_ITEM_ID
ColumnDELETED_FLAG
Columns
Name Datatype Length Mandatory Comments
CONFIG_HDR_ID NUMBER
Yes Configuration header identifier
CONFIG_INPUT_ID NUMBER
Yes Unique configuration input identifier
CONFIG_REV_NBR NUMBER (9) Yes Configuration revision number
PS_NODE_ID NUMBER (15)
Product structure node identifier
INPUT_VAL VARCHAR2 (4000)
Input value
INPUT_SEQ NUMBER (9)
Input sequence number
INSTANCE_NBR NUMBER

Instance identifier of the component instance
PARENT_INPUT_ID NUMBER

Identifier of the parent input
VIRTUAL_FLAG VARCHAR2 (1)
INPUT_TYPE_CODE NUMBER
Yes Input type code: LOGIC = 1; TEXT = 2; NUMERIC = 3; COMPONENT = 4; COMPONENT_SET = 5; CONNECTOR = 7. OBSOLETE: 0 "empty"
NODE_IDENTIFIER VARCHAR2 (1200)
Alternative configuration item identifier for the object against which this input was made
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
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
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
SECURITY_MASK VARCHAR2 (40)
Not currently used
EFF_MASK VARCHAR2 (40)
Not currently used
CHECKOUT_USER VARCHAR2 (40)
Not currently used
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
INSTANCE_ACTION_TYPE NUMBER (9)
Describes instantiation-related actions effected by this input.
CONFIG_ITEM_ID NUMBER (15) Yes Identifies the Saved Configuration Item against which this input was asserted.
TARGET_CONFIG_INPUT_ID NUMBER

Applies to Connection inputs. Identifies the input that created the target component of the Connection.
TARGET_CONFIG_ITEM_ID NUMBER

Applies to Connection inputs. Identifies the target component of the Connection.
INPUT_NUM_VAL NUMBER

Stores numeric input values.
SEARCH_OUTPUT_DECISION_FLAG VARCHAR2 (1)
FLOAT_TYPE NUMBER (9)
INPUT_SOURCE NUMBER (9)
CONTAINMENT_INSTANCE_HDR_ID NUMBER

A foreign key to cz_config_items.instance_hdr_id for inputs with input_type_code in (8,9)
Query Text

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


SELECT CONFIG_HDR_ID
,      CONFIG_INPUT_ID
,      CONFIG_REV_NBR
,      PS_NODE_ID
,      INPUT_VAL
,      INPUT_SEQ
,      INSTANCE_NBR
,      PARENT_INPUT_ID
,      VIRTUAL_FLAG
,      INPUT_TYPE_CODE
,      NODE_IDENTIFIER
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      DELETED_FLAG
,      EFF_FROM
,      EFF_TO
,      CREATED_BY
,      LAST_UPDATED_BY
,      SECURITY_MASK
,      EFF_MASK
,      CHECKOUT_USER
,      LAST_UPDATE_LOGIN
,      INSTANCE_ACTION_TYPE
,      CONFIG_ITEM_ID
,      TARGET_CONFIG_INPUT_ID
,      TARGET_CONFIG_ITEM_ID
,      INPUT_NUM_VAL
,      SEARCH_OUTPUT_DECISION_FLAG
,      FLOAT_TYPE
,      INPUT_SOURCE
,      CONTAINMENT_INSTANCE_HDR_ID
FROM CZ.CZ_CONFIG_INPUTS;

Dependencies

[top of page]

CZ.CZ_CONFIG_INPUTS does not reference any database object

CZ.CZ_CONFIG_INPUTS is referenced by following:

SchemaAPPS
SynonymCZ_CONFIG_INPUTS
TriggerCZ_CONFIG_INPUTS_T1