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

TABLE: CZ.CZ_IMP_ITEM_TYPE_PROPERTY

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


CZ_IMP_ITEM_TYPE_PROPERTY contains data that will be imported (or rejected) into CZ_ITEM_TYPE_PROPERTIES table by the import process.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CZ_IMP_ITEM_TYPE_PROPERTY_N0 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnRUN_ID
ColumnREC_STATUS
CZ_IMP_ITEM_TYPE_PROPERTY_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnFSK_ITEMTYPE_1_1
CZ_IMP_ITEM_TYPE_PROPERTY_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnITEM_TYPE_ID
CZ_IMP_ITEM_TYPE_PROPERTY_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnPROPERTY_ID
Columns
Name Datatype Length Mandatory Comments
ITEM_TYPE_ID NUMBER (9)
ID of item type to which the property is assigned
PROPERTY_ID NUMBER (9)
ID of property assigned to item type
REC_NBR NUMBER

Provides a one-up sequence number identifying the record in this run
RUN_ID NUMBER

Contains a number indicating the import run in which this record was loaded/processed
REC_STATUS VARCHAR2 (4)
Records a coded status describing the import results for this record; if null, it indicates the record has not yet it indicates the record has not yet been completely processed
DISPOSITION VARCHAR2 (1)
Indicates whether the record was inserted, updated, unchanged, or rejected
DELETED_FLAG VARCHAR2 (1) Yes Indicates ('1'/'0') that this record has been deleted
EFF_FROM DATE

UNUSED
EFF_TO DATE

UNUSED
EFF_MASK VARCHAR2 (40)
UNUSED
USER_STR01 VARCHAR2 (255)
Textual user expansion field
USER_STR02 VARCHAR2 (255)
Textual user expansion field
USER_STR03 VARCHAR2 (255)
Textual user expansion field
USER_STR04 VARCHAR2 (255)
Textual user expansion field
USER_NUM01 NUMBER (16)
Numeric user expansion field
USER_NUM02 NUMBER (16)
Numeric user expansion field
USER_NUM03 NUMBER (16)
Numeric user expansion field
USER_NUM04 NUMBER (16)
Numeric user expansion field
CHECKOUT_USER VARCHAR2 (40)
UNUSED
CREATION_DATE DATE

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
CREATED_BY NUMBER (15)
Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
SECURITY_MASK VARCHAR2 (40)
UNUSED
FSK_ITEMTYPE_1_1 VARCHAR2 (255)
Contains a foreign surrogate-key value matching IMP_ITEM_TYPE on NAME
FSK_ITEMTYPE_1_EXT VARCHAR2 (255)
Contains a foreign surrogate-key value matching IMP_ITEM_TYPE on USER_STR03
FSK_PROPERTY_2_1 VARCHAR2 (255)
Contains a foreign surrogate-key value matching IMP_PROPERTY on NAME
FSK_PROPERTY_2_EXT VARCHAR2 (255)
Contains a foreign surrogate-key value matching IMP_PROPERTY on USER_STR03
LAST_UPDATE_LOGIN NUMBER

Standard Who column
ORIG_SYS_REF VARCHAR2 (2000)
Contains reference to the source record from which this record was extracted
SRC_APPLICATION_ID NUMBER

Query Text

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


SELECT ITEM_TYPE_ID
,      PROPERTY_ID
,      REC_NBR
,      RUN_ID
,      REC_STATUS
,      DISPOSITION
,      DELETED_FLAG
,      EFF_FROM
,      EFF_TO
,      EFF_MASK
,      USER_STR01
,      USER_STR02
,      USER_STR03
,      USER_STR04
,      USER_NUM01
,      USER_NUM02
,      USER_NUM03
,      USER_NUM04
,      CHECKOUT_USER
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      SECURITY_MASK
,      FSK_ITEMTYPE_1_1
,      FSK_ITEMTYPE_1_EXT
,      FSK_PROPERTY_2_1
,      FSK_PROPERTY_2_EXT
,      LAST_UPDATE_LOGIN
,      ORIG_SYS_REF
,      SRC_APPLICATION_ID
FROM CZ.CZ_IMP_ITEM_TYPE_PROPERTY;

Dependencies

[top of page]

CZ.CZ_IMP_ITEM_TYPE_PROPERTY does not reference any database object

CZ.CZ_IMP_ITEM_TYPE_PROPERTY is referenced by following:

SchemaCZ
ViewCZ_IMP_ITEM_TYPE_PROPERTY#