[Home] [Help] [Dependency Information]
Object Name: | CZ_IMP_DEVL_PROJECT |
---|---|
Object Type: | TABLE |
Owner: | CZ |
FND Design Data: | CZ.CZ_IMP_DEVL_PROJECT |
Subobject Name: | |
Status: | VALID |
CZ_IMP_DEVL_PROJECT contains data that will be imported (or rejected) into CZ_DEVL_PROJECTS table by the import process.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CZ_IMP_DEVL_PROJECT_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
RUN_ID
DEVL_PROJECT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DEVL_PROJECT_ID | NUMBER | (15) | SPX identifier for the development project | |
INTL_TEXT_ID | NUMBER | (15) | SPX international text identifier for this project | |
ORGANIZATION_ID | NUMBER | (9) | Organization identifier for the top item | |
NAME | VARCHAR2 | (255) | Project name | |
GSL_FILENAME | VARCHAR2 | (255) | UNUSED | |
TOP_ITEM_ID | NUMBER | (9) | Bill top item identifier | |
VERSION | NUMBER | (9) | Project version number | |
EXPLOSION_TYPE | VARCHAR2 | (20) | Bill explosion type: all, optional, or included. | |
DESC_TEXT | VARCHAR2 | (2000) | Project description | |
ORIG_SYS_REF | VARCHAR2 | (255) | Unique identification of a record in this table | |
CREATION_DATE | DATE | Date this record was created | ||
LAST_UPDATE_DATE | DATE | Date this record was last updated | ||
DELETED_FLAG | VARCHAR2 | (1) | Yes | Indicates ('1'/'0') that this record has been deleted |
EFF_FROM | DATE | UNUSED | ||
EFF_TO | DATE | UNUSED | ||
CREATED_BY | NUMBER | (15) | Standard field recording the ID of the user that created this record | |
LAST_UPDATED_BY | NUMBER | (15) | 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 | |
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 | |
FSK_INTLTEXT_1_1 | VARCHAR2 | (255) | Contains a foreign surrogate-key value matching IMP_INTL_TEXT on TEXT_STR | |
MODEL_ID | NUMBER | (15) | New model_id under which this model is imported. | |
PLAN_LEVEL | NUMBER | (9) | Used in resolving models when importing a composite BOM | |
PERSISTENT_PROJECT_ID | NUMBER | (15) | New field, persistent ID of project/model. | |
MODEL_TYPE | VARCHAR2 | (1) | Yes | Declares the type of Configuration Model: S - solution model; P - PTO model; A - ATO model; C - non-BOM model (the default value) |
INVENTORY_ITEM_ID | NUMBER | Inventory item used for publication lookup in session that last saved this config | ||
PRODUCT_KEY | VARCHAR2 | (255) | Product key from lookup for last session | |
LAST_UPDATE_LOGIN | NUMBER | Standard footprint field. Login identity of user that last updated this record. | ||
BOM_CAPTION_RULE_ID | NUMBER | |||
NONBOM_CAPTION_RULE_ID | NUMBER | |||
SEEDED_FLAG | VARCHAR2 | (1) | '1' indicates this record is part of delivered Configurator application | |
CONFIG_ENGINE_TYPE | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT DEVL_PROJECT_ID
, INTL_TEXT_ID
, ORGANIZATION_ID
, NAME
, GSL_FILENAME
, TOP_ITEM_ID
, VERSION
, EXPLOSION_TYPE
, DESC_TEXT
, ORIG_SYS_REF
, CREATION_DATE
, LAST_UPDATE_DATE
, DELETED_FLAG
, EFF_FROM
, EFF_TO
, CREATED_BY
, LAST_UPDATED_BY
, SECURITY_MASK
, EFF_MASK
, CHECKOUT_USER
, RUN_ID
, REC_STATUS
, DISPOSITION
, FSK_INTLTEXT_1_1
, MODEL_ID
, PLAN_LEVEL
, PERSISTENT_PROJECT_ID
, MODEL_TYPE
, INVENTORY_ITEM_ID
, PRODUCT_KEY
, LAST_UPDATE_LOGIN
, BOM_CAPTION_RULE_ID
, NONBOM_CAPTION_RULE_ID
, SEEDED_FLAG
, CONFIG_ENGINE_TYPE
FROM CZ.CZ_IMP_DEVL_PROJECT;
CZ.CZ_IMP_DEVL_PROJECT does not reference any database object
CZ.CZ_IMP_DEVL_PROJECT is referenced by following:
|
|
|