[Home] [Help] [Dependency Information]
Object Name: | BOM_COPY_EXPLOSIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BOM.BOM_COPY_EXPLOSIONS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TOP_BILL_SEQUENCE_ID | NUMBER | Yes | Top Bill Sequence Id of the Exploded Structure | |
BILL_SEQUENCE_ID | NUMBER | Yes | Bill Sequence Id of the structure | |
ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
EXPLOSION_TYPE | VARCHAR2 | (20) | Explosion type | |
COMPONENT_SEQUENCE_ID | NUMBER | Sequence id of the component | ||
COMPONENT_ITEM_ID | NUMBER | Component item identifier | ||
PLAN_LEVEL | NUMBER | Yes | Level in bill | |
SORT_ORDER | VARCHAR2 | (2000) | Yes | Sorting sequence of the explosion |
TOP_ITEM_ID | NUMBER | Item id of evel 0 item | ||
COMPONENT_QUANTITY | NUMBER | Component quantity | ||
BOM_ITEM_TYPE | NUMBER | Type of item | ||
PICK_COMPONENTS_FLAG | VARCHAR2 | (1) | indicating if the shippable items should bep icked | |
REPLENISH_TO_ORDER_FLAG | VARCHAR2 | (1) | Assemble to order flag | |
ASSEMBLY_ITEM_ID | NUMBER | Assembled item id | ||
COMPONENT_CODE | VARCHAR2 | (4000) | Component code | |
LOOP_FLAG | NUMBER | Indicates whether a loop is detected | ||
PARENT_BOM_ITEM_TYPE | NUMBER | Parent Item's BOM item type | ||
EFFECTIVITY_DATE | DATE | Effective date | ||
DISABLE_DATE | DATE | Disable date | ||
IMPLEMENTATION_DATE | DATE | Implementation date | ||
COMMON_BILL_SEQUENCE_ID | NUMBER | Common Bill's unique identifier of parent | ||
COMP_BILL_SEQ_ID | NUMBER | Component bill's unique identifier | ||
COMP_COMMON_BILL_SEQ_ID | NUMBER | Component's common Bill's unique identifier | ||
EXPLODE_GROUP_ID | NUMBER | not used | ||
ITEM_NAME | VARCHAR2 | (40) | Item name | |
ALTERNATE_BOM_DESIGNATOR | VARCHAR2 | (4000) | Alternate BOM designator | |
CURRENT_ITEM_REVISION | VARCHAR2 | (4000) | Current revision of the item | |
REVISION_LABEL | VARCHAR2 | (4000) | Revision label of the item | |
CHANGE_NOTICE | VARCHAR2 | (10) | Engineerin change notice | |
CHANGE_ID | NUMBER | Change identifier | ||
ENG_ITEM_FLAG | VARCHAR2 | (1) | Flag indicating if the item is a change item | |
PARENT_SORT_ORDER | VARCHAR2 | (2000) | Sort order of the Parent | |
REVISION_CODE | VARCHAR2 | (4000) | Revision code | |
STRUCTURE_TYPE_ID | NUMBER | Structure type identifier | ||
PK1_VALUE | VARCHAR2 | (240) | Primary key of the object | |
PK2_VALUE | VARCHAR2 | (240) | Primary key of the object | |
PK3_VALUE | VARCHAR2 | (240) | Primary key of the object | |
PK4_VALUE | VARCHAR2 | (240) | Primary key of the object | |
PK5_VALUE | VARCHAR2 | (240) | Primary key of the object | |
OBJ_NAME | VARCHAR2 | (30) | Object name | |
REVISION_ID | NUMBER | Revision identifier | ||
FROM_MINOR_REVISION_ID | NUMBER | From minor revision id | ||
TO_MINOR_REVISION_ID | NUMBER | To minor revision id | ||
FROM_END_ITEM_REV_ID | NUMBER | From end item revision id | ||
TO_END_ITEM_REV_ID | NUMBER | To end item revision id | ||
FROM_END_ITEM_MINOR_REV_ID | NUMBER | From end item minor revision id | ||
TO_END_ITEM_MINOR_REV_ID | NUMBER | To end item minor revision id | ||
EFFECTIVITY_CONTROL | NUMBER | Effectivity control | ||
ACCESS_FLAG | VARCHAR2 | (4000) | Access flag | |
BOM_IMPLEMENTATION_DATE | DATE | BOM Implementation date | ||
MINOR_REVISION | NUMBER | Minor revision | ||
ASSEMBLY_TYPE | NUMBER | Assembly type | ||
ACD_TYPE | NUMBER | ACD type | ||
FROM_END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | From end item unit number | |
TO_END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | To end item unit number | |
CHANGE_POLICY_VALUE | VARCHAR2 | (240) | Change policy value | |
IS_EXCLUDED_BY_RULE | VARCHAR2 | (4000) | BOM explosion excluded by rule | |
GROUP_ID | NUMBER | Group id | ||
PARENT_IMPLEMENTATION_DATE | DATE | Parent implementation date | ||
PARENT_CHANGE_NOTICE | VARCHAR2 | (10) | Parent change notice | |
COMP_FIXED_REV_CODE | VARCHAR2 | (4000) | Component fixed revision code | |
SOURCE_BILL_SEQUENCE_ID | NUMBER | Source bill sequence id | ||
COMMON_COMPONENT_SEQUENCE_ID | NUMBER | Common component sequence id | ||
COMP_SOURCE_BILL_SEQ_ID | NUMBER | Component source bill sequence id | ||
CATALOG_CATEGORY_ID | NUMBER | Catalog category id | ||
COMMON_ORGANIZATION_ID | NUMBER | Organization id of common bill | ||
ITEM_STATUS | VARCHAR2 | (10) | Yes | Item status |
CREATION_DATE | DATE | Standard WHO column | ||
CREATED_BY | NUMBER | Standard WHO column | ||
LAST_UPDATE_DATE | DATE | Standard WHO column | ||
LAST_UPDATED_BY | NUMBER | Standard WHO column |
Cut, paste (and edit) the following text to query this object:
SELECT TOP_BILL_SEQUENCE_ID
, BILL_SEQUENCE_ID
, ORGANIZATION_ID
, EXPLOSION_TYPE
, COMPONENT_SEQUENCE_ID
, COMPONENT_ITEM_ID
, PLAN_LEVEL
, SORT_ORDER
, TOP_ITEM_ID
, COMPONENT_QUANTITY
, BOM_ITEM_TYPE
, PICK_COMPONENTS_FLAG
, REPLENISH_TO_ORDER_FLAG
, ASSEMBLY_ITEM_ID
, COMPONENT_CODE
, LOOP_FLAG
, PARENT_BOM_ITEM_TYPE
, EFFECTIVITY_DATE
, DISABLE_DATE
, IMPLEMENTATION_DATE
, COMMON_BILL_SEQUENCE_ID
, COMP_BILL_SEQ_ID
, COMP_COMMON_BILL_SEQ_ID
, EXPLODE_GROUP_ID
, ITEM_NAME
, ALTERNATE_BOM_DESIGNATOR
, CURRENT_ITEM_REVISION
, REVISION_LABEL
, CHANGE_NOTICE
, CHANGE_ID
, ENG_ITEM_FLAG
, PARENT_SORT_ORDER
, REVISION_CODE
, STRUCTURE_TYPE_ID
, PK1_VALUE
, PK2_VALUE
, PK3_VALUE
, PK4_VALUE
, PK5_VALUE
, OBJ_NAME
, REVISION_ID
, FROM_MINOR_REVISION_ID
, TO_MINOR_REVISION_ID
, FROM_END_ITEM_REV_ID
, TO_END_ITEM_REV_ID
, FROM_END_ITEM_MINOR_REV_ID
, TO_END_ITEM_MINOR_REV_ID
, EFFECTIVITY_CONTROL
, ACCESS_FLAG
, BOM_IMPLEMENTATION_DATE
, MINOR_REVISION
, ASSEMBLY_TYPE
, ACD_TYPE
, FROM_END_ITEM_UNIT_NUMBER
, TO_END_ITEM_UNIT_NUMBER
, CHANGE_POLICY_VALUE
, IS_EXCLUDED_BY_RULE
, GROUP_ID
, PARENT_IMPLEMENTATION_DATE
, PARENT_CHANGE_NOTICE
, COMP_FIXED_REV_CODE
, SOURCE_BILL_SEQUENCE_ID
, COMMON_COMPONENT_SEQUENCE_ID
, COMP_SOURCE_BILL_SEQ_ID
, CATALOG_CATEGORY_ID
, COMMON_ORGANIZATION_ID
, ITEM_STATUS
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
FROM APPS.BOM_COPY_EXPLOSIONS_V;
|
|
|