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

TABLE: CZ.CZ_IMP_ITEM_PARENT

Object Details
Object Name: CZ_IMP_ITEM_PARENT
Object Type: TABLE
Owner: CZ
FND Design Data: TableCZ.CZ_IMP_ITEM_PARENT
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.

Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
PARENT_ITEM_ID NUMBER (9)
Designates an SPX identifier for the parent item
ITEM_ID NUMBER (9)
Associates an Item Master record with this record
REL_TYPE_ID NUMBER (9)
Associates this record with a parent/child relationship type
SEQ_NBR NUMBER (9)
Provides an ordering among associated records
REC_NBR NUMBER

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

Associates this record with a specific batch run (import, publish, purge, etc.)
REC_STATUS VARCHAR2 (4)
Coded description of the import status of this record; 'OK' indicates success
DISPOSITION VARCHAR2 (1)
Indicates whether the record was inserted, updated, unchanged, or rejected
DELETED_FLAG VARCHAR2 (1) Yes Standard flag; '0' indicates the record is active, '1' means deleted. Other values are reserved
EFF_FROM DATE

UNUSED
EFF_TO DATE

UNUSED
EFF_MASK VARCHAR2 (40)
UNUSED
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 (16)
Standard extension field (numeric)
USER_NUM02 NUMBER (16)
Standard extension field (numeric)
USER_NUM03 NUMBER (16)
Standard extension field (numeric)
USER_NUM04 NUMBER (16)
Standard extension field (numeric)
CHECKOUT_USER VARCHAR2 (40)
UNUSED
CREATION_DATE DATE

Standard field recording the date this record was created
LAST_UPDATE_DATE DATE

Standard field recording the date/time this record was last updated
CREATED_BY NUMBER (15)
Standard field recording the ID of the user that created this record
LAST_UPDATED_BY NUMBER (15)
Standard field recording the ID of the user that last updated this record
SECURITY_MASK VARCHAR2 (40)
UNUSED
FSK_ITEMMASTER_1_1 VARCHAR2 (255)
Contains a foreign surrogate-key value matching CZ_ITEM_MASTERS on parent_item_id
FSK_ITEMMASTER_1_EXT VARCHAR2 (255)
Contains a foreign surrogate-key value matching CZ_ITEM_MASTERS on user_str01
FSK_ITEMMASTER_2_1 VARCHAR2 (255)
Contains a foreign surrogate-key value matching CZ_ITEM_MASTERS on ITEM_ID
FSK_ITEMMASTER_2_EXT VARCHAR2 (255)
Contains a foreign surrogate-key value matching CZ_ITEM_MASTERS on user_str02
Query Text

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


SELECT PARENT_ITEM_ID
,      ITEM_ID
,      REL_TYPE_ID
,      SEQ_NBR
,      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_ITEMMASTER_1_1
,      FSK_ITEMMASTER_1_EXT
,      FSK_ITEMMASTER_2_1
,      FSK_ITEMMASTER_2_EXT
FROM CZ.CZ_IMP_ITEM_PARENT;

Dependencies

[top of page]

CZ.CZ_IMP_ITEM_PARENT does not reference any database object

CZ.CZ_IMP_ITEM_PARENT is referenced by following:

SchemaAPPS
SynonymCZ_IMP_ITEM_PARENT