[Home] [Help] [Dependency Information]
Object Name: | CZ_IMP_ADDRESS_USE |
---|---|
Object Type: | TABLE |
Owner: | CZ |
FND Design Data: | CZ.CZ_IMP_ADDRESS_USE |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CZ_IMP_ADDRESS_USE_N0 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE |
RUN_ID
REC_STATUS |
CZ_IMP_ADDRESS_USE_N1 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | ORIG_SYS_REF |
CZ_IMP_ADDRESS_USE_N2 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | ADDRESS_USE_ID |
CZ_IMP_ADDRESS_USE_N3 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | FSK_ADDRESS_1_1 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ADDRESS_USE_ID | NUMBER | (9) | SPX Address use identifier | |
ADDRESS_ID | NUMBER | (9) | SPX Address identifier | |
ORIG_SYS_REF | VARCHAR2 | (255) | Unique identification of a record in this table | |
SITE_USE_CODE | VARCHAR2 | (20) | Site use code | |
WAREHOUSE_ID | NUMBER | SPX warehouse identifier for this address use | ||
DELETED_FLAG | VARCHAR2 | (1) | Yes | Flag indicating if record was deleted by the user. If deleted_flag=1 the record will be purged. |
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 been completely processed | |
DISPOSITION | VARCHAR2 | (1) | Indicates whether the record was inserted, updated, unchanged, or rejected | |
FSK_ADDRESS_1_1 | VARCHAR2 | (255) | Contains a foreign surrogate-key value matching IMP_ADDRESS on ORIG_SYS_REF |
Cut, paste (and edit) the following text to query this object:
SELECT ADDRESS_USE_ID
, ADDRESS_ID
, ORIG_SYS_REF
, SITE_USE_CODE
, WAREHOUSE_ID
, DELETED_FLAG
, RUN_ID
, REC_STATUS
, DISPOSITION
, FSK_ADDRESS_1_1
FROM CZ.CZ_IMP_ADDRESS_USE;
CZ.CZ_IMP_ADDRESS_USE does not reference any database object
CZ.CZ_IMP_ADDRESS_USE is referenced by following:
|
|
|