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

TABLE: CZ.CZ_IMP_END_USER

Object Details
Object Name: CZ_IMP_END_USER
Object Type: TABLE
Owner: CZ
FND Design Data: TableCZ.CZ_IMP_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
END_USER_ID NUMBER (9)
SPX end user identifier
END_USER_ORG_ID NUMBER

Apps organization identifier this user belongs to
ORIG_SYS_REF VARCHAR2 (255)
Unique identification of a record in this table
TITLE VARCHAR2 (48)
Title
LOGIN_NAME VARCHAR2 (48)
Login name
LASTNAME VARCHAR2 (48)
Last name
FIRSTNAME VARCHAR2 (48)
First name
MI VARCHAR2 (1)
Middle initial
ALLOWABLE_DISCOUNT NUMBER (16)
Maximum allowable discount
DESC_TEXT VARCHAR2 (255)
Description
ADDR_LINE1 VARCHAR2 (150)
Address line1
ADDR_LINE2 VARCHAR2 (150)
Address line2
CITY VARCHAR2 (56)
City
STATE VARCHAR2 (8)
State
PROVINCE VARCHAR2 (56)
Province
COUNTY VARCHAR2 (56)
County
ZIP VARCHAR2 (24)
Zip
COUNTRY VARCHAR2 (56)
Country
PHONE VARCHAR2 (48)
Phone
FAX VARCHAR2 (48)
Fax
PAGER VARCHAR2 (48)
Pager
CELLULAR VARCHAR2 (48)
Cellular
EMAIL_ADDR VARCHAR2 (150)
Email address
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

Not currently used
EFF_TO DATE

Not currently used
EFF_MASK VARCHAR2 (40)
Not currently used
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)
Not currently used
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)
Not currently used
FSK_ENDUSER_1_1 VARCHAR2 (255)
Not currently used
FSK_ENDUSER_1_EXT VARCHAR2 (255)
Not currently used
FSK_USERGROUP_2_1 VARCHAR2 (255)
Not currently used
FSK_USERGROUP_2_EXT VARCHAR2 (255)
Not currently used
NAME VARCHAR2 (255)
Name
Query Text

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


SELECT END_USER_ID
,      END_USER_ORG_ID
,      ORIG_SYS_REF
,      TITLE
,      LOGIN_NAME
,      LASTNAME
,      FIRSTNAME
,      MI
,      ALLOWABLE_DISCOUNT
,      DESC_TEXT
,      ADDR_LINE1
,      ADDR_LINE2
,      CITY
,      STATE
,      PROVINCE
,      COUNTY
,      ZIP
,      COUNTRY
,      PHONE
,      FAX
,      PAGER
,      CELLULAR
,      EMAIL_ADDR
,      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_ENDUSER_1_1
,      FSK_ENDUSER_1_EXT
,      FSK_USERGROUP_2_1
,      FSK_USERGROUP_2_EXT
,      NAME
FROM CZ.CZ_IMP_END_USER;

Dependencies

[top of page]

CZ.CZ_IMP_END_USER does not reference any database object

CZ.CZ_IMP_END_USER is referenced by following:

SchemaAPPS
SynonymCZ_IMP_END_USER