[Home] [Help] [Dependency Information]
Object Name: | CZ_XFR_PROJECT_BILLS |
---|---|
Object Type: | TABLE |
Owner: | CZ |
FND Design Data: | CZ.CZ_XFR_PROJECT_BILLS |
Subobject Name: | |
Status: | VALID |
CZ_XFR_PROJECT_BILLS is used to specify the Oracle Bills of Material which will be imported from BOM_EXPLOSIONS table. TOP_BILL_SEQUENCE_ID, ORGANIZATION_ID, and DELETED_FLAG are supposed to be specified before import.
Other fields may be updated during import. For every record in this table with DELETED_FLAG not equal to ?1?, the extraction procedure checks if the source bill defined by ORGANIZATION_ID and TOP_BILL_SEQUENCE_ID (implicitly, EXPLOSION_TYPE=?OPTIONAL? and PLAN_LEVEL=0 are suggested) exists in Oracle Applications BOM_EXPLOSIONS table. If it exists, the procedure sets the SOURCE_BILL_DELETED field to ?0? (not deleted) and extracts the bill data. If the source bill doesn?t exist, the SOURCE_BILL_DELETED field is set to ?1?. Once the bill is extracted, LAST_IMPORT_RUN_ID, LAST_IMPORT_DATE, DESCRIPTION, and COMPONENT_ITEM_ID fields
are filled with corresponding values.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CZ_XFR_PROJ_BILLS_PK | NORMAL | UNIQUE | APPS_TS_SEED | MODEL_PS_NODE_ID |
CZ_XFR_PROJECT_BILLS_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED |
ORGANIZATION_ID
TOP_ITEM_ID EXPLOSION_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MODEL_PS_NODE_ID | NUMBER | (15) | Yes | Project structure node identifier for the model. |
ORGANIZATION_ID | NUMBER | Yes | Organization identifier from the Oracle Bills of Material for the bill to be imported | |
COMPONENT_ITEM_ID | NUMBER | Component item identifier of the top item from the Oracle Bills of Material for the bill to be imported | ||
DESCRIPTION | VARCHAR2 | (255) | Import description | |
LAST_IMPORT_RUN_ID | NUMBER | Identifier of of the last import in which this bill was transferred | ||
LAST_IMPORT_DATE | DATE | Date of the last import | ||
SOURCE_BILL_DELETED | VARCHAR2 | (1) | '1' Indicates the bill import logic detected that the source bill was deleted from Oracle Apps | |
TOP_ITEM_ID | NUMBER | Yes | Inventory identifier of the top item | |
DELETED_FLAG | VARCHAR2 | (1) | Yes | Indicates whether a model has been disabled for BOM refresh. |
EXPLOSION_TYPE | VARCHAR2 | (10) | Yes | Explosion type: All, Included, Optional |
BILL_REVISION_DATE | DATE | Bill revision date | ||
EFF_FROM | DATE | Bill effective from date | ||
EFF_TO | DATE | Bill effective to date | ||
SOURCE_SERVER | NUMBER | (9) | Yes | Specifies from which remote server this BOM is being imported. (Note - must identify the CZ_SERVERS record for which import is enabled) |
COPY_ADDL_CHILD_MODELS | VARCHAR2 | (1) | Flag indicating refresh treatment of component models added to BOM since last import; 0 = reference existing models if available; 1 = always import copies of newly-added models |
Cut, paste (and edit) the following text to query this object:
SELECT MODEL_PS_NODE_ID
, ORGANIZATION_ID
, COMPONENT_ITEM_ID
, DESCRIPTION
, LAST_IMPORT_RUN_ID
, LAST_IMPORT_DATE
, SOURCE_BILL_DELETED
, TOP_ITEM_ID
, DELETED_FLAG
, EXPLOSION_TYPE
, BILL_REVISION_DATE
, EFF_FROM
, EFF_TO
, SOURCE_SERVER
, COPY_ADDL_CHILD_MODELS
FROM CZ.CZ_XFR_PROJECT_BILLS;
CZ.CZ_XFR_PROJECT_BILLS does not reference any database object
CZ.CZ_XFR_PROJECT_BILLS is referenced by following:
|
|
|