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

TABLE: CZ.CZ_IMP_CUSTOMER_END_USER

Object Details
Object Name: CZ_IMP_CUSTOMER_END_USER
Object Type: TABLE
Owner: CZ
FND Design Data: TableCZ.CZ_IMP_CUSTOMER_END_USER
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_ARCHIVE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
CUSTOMER_ID NUMBER (9)
Oracle SellingPoint customer identifier
END_USER_ID NUMBER (9)
Oracle SellingPoint end user identifier
CREATION_DATE DATE

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
DELETED_FLAG VARCHAR2 (1) Yes Indicates ('1'/'0') that this record has been deleted
EFF_FROM DATE

Not currently used
EFF_TO DATE

Not currently used
CREATED_BY NUMBER (15)
Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
SECURITY_MASK VARCHAR2 (40)
Not currently used
EFF_MASK VARCHAR2 (40)
Not currently used
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
CHECKOUT_USER VARCHAR2 (40)
Not currently used
FSK_CUSTOMER_1_1 VARCHAR2 (255)
Contains a foreign surrogate-key value matching IMP_CUSTOMERS on ORIG_SYS_REF
FSK_ENDUSER_2_1 VARCHAR2 (255)
Contains a foreign surrogate-key value matching IMP_END_USER on LOGIN_NAME
FSK_ENDUSER_2_EXT VARCHAR2 (255)
Contains a foreign surrogate-key value matching IMP_END_USER on USER_STR03
Query Text

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


SELECT CUSTOMER_ID
,      END_USER_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      DELETED_FLAG
,      EFF_FROM
,      EFF_TO
,      CREATED_BY
,      LAST_UPDATED_BY
,      SECURITY_MASK
,      EFF_MASK
,      REC_NBR
,      RUN_ID
,      REC_STATUS
,      DISPOSITION
,      CHECKOUT_USER
,      FSK_CUSTOMER_1_1
,      FSK_ENDUSER_2_1
,      FSK_ENDUSER_2_EXT
FROM CZ.CZ_IMP_CUSTOMER_END_USER;

Dependencies

[top of page]

CZ.CZ_IMP_CUSTOMER_END_USER does not reference any database object

CZ.CZ_IMP_CUSTOMER_END_USER is referenced by following:

SchemaAPPS
SynonymCZ_IMP_CUSTOMER_END_USER