[Home] [Help]
[Dependency Information]
| Object Name: | CZ_POPULATOR_MAPS |
|---|---|
| Object Type: | TABLE |
| Owner: | CZ |
| FND Design Data: | CZ.CZ_POPULATOR_MAPS
|
| 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_SEED |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| CZ_POPULATOR_MAPS_PK | NORMAL | UNIQUE |
APPS_TS_SEED
|
POP_MAP_ID
POPULATOR_ID
|
| CZ_POPULATOR_MAPS_N1 | NORMAL | NONUNIQUE |
APPS_TS_SEED
|
POPULATOR_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LAST_UPDATE_LOGIN | NUMBER | (15) | Records the login ID under which this record was last updated | |
| POP_MAP_ID | NUMBER | (9) | Yes | Identity for this populator-map record within a populator |
| POPULATOR_ID | NUMBER | (9) | Yes | Identifies the populator to which this populator-map entry belongs |
| SOURCE_COL | VARCHAR2 | (80) | Yes | Holds the name of the source column for a populated field |
| RESULT_COL | VARCHAR2 | (80) | Yes | Name of the output column resulting from this populator map entry |
| CREATION_DATE | DATE | Yes | Standard field recording the date this record was created | |
| LAST_UPDATE_DATE | DATE | Yes | Standard field recording the date/time this record was last updated | |
| 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 | ||
| CREATED_BY | NUMBER | (15) | Yes | Standard field recording the ID of the user that created this record |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard field recording the ID of the user that last updated this record |
| SECURITY_MASK | VARCHAR2 | (40) | UNUSED | |
| EFF_MASK | VARCHAR2 | (40) | UNUSED | |
| CHECKOUT_USER | VARCHAR2 | (40) | UNUSED |
Cut, paste (and edit) the following text to query this object:
SELECT LAST_UPDATE_LOGIN
, POP_MAP_ID
, POPULATOR_ID
, SOURCE_COL
, RESULT_COL
, CREATION_DATE
, LAST_UPDATE_DATE
, DELETED_FLAG
, EFF_FROM
, EFF_TO
, CREATED_BY
, LAST_UPDATED_BY
, SECURITY_MASK
, EFF_MASK
, CHECKOUT_USER
FROM CZ.CZ_POPULATOR_MAPS;
CZ.CZ_POPULATOR_MAPS does not reference any database object
CZ.CZ_POPULATOR_MAPS is referenced by following:
APPS
CZ_POPULATOR_MAPS
CZ_POPULATOR_MAPS_T1
|
|
|
|