[Home] [Help] [Dependency Information]
Object Name: | CN_IMPORT_TYPES |
---|---|
Object Type: | TABLE |
Owner: | CN |
FND Design Data: | CN.CN_IMPORT_TYPES |
Subobject Name: | |
Status: | VALID |
CN_IMPORT_TYPES store all module types can be imported into the application. You need one row for each module. For each imported module, the view will be used for staging the data and the concurrent program will be used to import data into destination table.
The user should never need to alter this table directly.
It is pre-seeded, and maintained by the system.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CN_IMPORT_TYPES_U1 | NORMAL | UNIQUE | APPS_TS_SEED | IMPORT_TYPE_ID |
CN_IMPORT_TYPES_U2 | NORMAL | UNIQUE | APPS_TS_SEED | IMPORT_TYPE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
IMPORT_TYPE_ID | NUMBER | (15) | Yes | Identifier |
IMPORT_TYPE_CODE | VARCHAR2 | (30) | Yes | Import Type code |
VIEW_NAME | VARCHAR2 | (30) | Yes | The seeded view used for staging the data for this module. |
CONC_PROGRAM | VARCHAR2 | (150) | The name of the concurrent program to be used for importing data into the destination table. | |
TABLE_ID | NUMBER | (15) | Yes | The object_id for the view in cn_objects_all. |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Standard Who column | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
EXPORT_CONC_PROGRAM | VARCHAR2 | (150) | The name of the concurrent program to be used for exporting data from the table. |
Cut, paste (and edit) the following text to query this object:
SELECT IMPORT_TYPE_ID
, IMPORT_TYPE_CODE
, VIEW_NAME
, CONC_PROGRAM
, TABLE_ID
, OBJECT_VERSION_NUMBER
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, EXPORT_CONC_PROGRAM
FROM CN.CN_IMPORT_TYPES;
CN.CN_IMPORT_TYPES does not reference any database object
CN.CN_IMPORT_TYPES is referenced by following:
|
|
|