DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.BOM_COPY_EXPLOSIONS_V

Object Details
Object Name: BOM_COPY_EXPLOSIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.BOM_COPY_EXPLOSIONS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.BOM_COPY_EXPLOSIONS_V references the following:

SchemaAPPS
PL/SQL PackageBOM_EXPLODER_PUB - show dependent code
SynonymBOM_EXPLOSIONS_ALL
PL/SQL PackageBOM_GLOBALS - show dependent code
SynonymMTL_ITEM_REVISIONS_B
ViewMTL_SYSTEM_ITEMS_B_KFV
APPS.BOM_COPY_EXPLOSIONS_V is referenced by following:

SchemaAPPS
Package BodyBOM_COPY_BILL - show dependent code