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

VIEW: APPS.BOM_EXPLOSION_VIEW

Object Details
Object Name: BOM_EXPLOSION_VIEW
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.BOM_EXPLOSION_VIEW
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 Bill identifier of top level bill
BILL_SEQUENCE_ID NUMBER
Yes Bill of material unique identifier
COMPONENT_SEQUENCE_ID NUMBER

Component unique identifier
COMPONENT_ITEM_ID NUMBER

Component item identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
OPERATION_SEQ_NUM NUMBER

Operation sequence number
PLAN_LEVEL NUMBER
Yes Level in indented structure
EXTENDED_QUANTITY NUMBER

Extended quantity
ITEM_NUM NUMBER

Sequence number in routing
SORT_ORDER VARCHAR2 (2000) Yes Sort order for retrieving tree information
GROUP_ID NUMBER

Group identifier
ITEM_COST NUMBER

Item cost
RESERVABLE_TYPE NUMBER

Flag to show if item is reservable
EXTEND_COST_FLAG NUMBER

Flag to show if costs should be extended
TOP_ALTERNATE_DESIGNATOR VARCHAR2 (10)
Alternate of top level bill
TOP_ITEM_ID NUMBER

Item identifier of top level bill
EFFECTIVITY_DATE DATE

Effective date
DISABLE_DATE DATE

Disable date
IMPLEMENTATION_DATE DATE

Implementation date
OPTIONAL NUMBER

Flag to show if component is optional
PLANNING_FACTOR NUMBER

Planning factor
COMPONENT_YIELD_FACTOR NUMBER

Component yield factor
INCLUDE_IN_COST_ROLLUP NUMBER

Flag to show if item should be included in cost rollup
WIP_SUPPLY_TYPE NUMBER

Supply type
SUPPLY_SUBINVENTORY VARCHAR2 (10)
Supply subinventory
SUPPLY_LOCATOR_ID NUMBER

Supply locator
COMPONENT_REMARKS VARCHAR2 (240)
Component remarks
CHANGE_NOTICE VARCHAR2 (10)
Engineering change order number
BASIS_TYPE VARCHAR2 (80)
COMPONENT_QUANTITY NUMBER

Quantity
OPERATION_LEAD_TIME_PERCENT NUMBER

Lead time percent
MUTUALLY_EXCLUSIVE_OPTIONS NUMBER

Flag to show if options below are mutually exclusive
CHECK_ATP NUMBER

Flag to indicate if ATP check should be performed
REQUIRED_TO_SHIP NUMBER

Flag to show if item is required to ship
SO_BASIS VARCHAR2 (80)
Order basis
REQUIRED_FOR_REVENUE NUMBER

Flag to show if item is required for revenue
INCLUDE_ON_SHIP_DOCS NUMBER

Flag to indicate if item is to be shown on shipping documents
MINIMUM_QUANTITY NUMBER

minimum order quantity
MAXIMUM_QUANTITY NUMBER

maximum order quantity
UNIT_OF_MEASURE VARCHAR2 (3)
Unit of measure
ITEM_TYPE VARCHAR2 (30)
User defined item type
DESCRIPTION VARCHAR2 (240)
Description
ENG_ITEM_FLAG VARCHAR2 (1) Yes Flag showing if item is an engineering item
CUM_MANUFACTURING_LEAD_TIME NUMBER

Cumulative manufacturing lead time
CUMULATIVE_TOTAL_LEAD_TIME NUMBER

Cumulative total lead time
MANUFACTURING_LEAD_TIME NUMBER

Manufacturing lead time
PARENT_ITEM_ID NUMBER

Parent item identifier
PARENT_ALTERNATE VARCHAR2 (10)
Alternate of parent bill
ENG_BILL NUMBER
Yes Flag showing if bill is an engineering bill
DISPLAY_PLAN_LEVEL VARCHAR2 (4000)
Formatted plan level
EFFECTIVITY_TIME VARCHAR2 (5)
Effective time
DISABLE_TIME VARCHAR2 (5)
Disable time
EXTENDED_QUANTITY6 NUMBER

Extended quantity
EXTENDED_COST NUMBER

Extended cost
OPERATION_SEQ_NUM7 NUMBER

Operation sequence number
BOM_ITEM_TYPE NUMBER
Yes BOM item type of item
REPLENISH_TO_ORDER_FLAG VARCHAR2 (1) Yes Flag showing if work ordered is opened for this item
PICK_COMPONENTS_FLAG VARCHAR2 (1) Yes Flag showing if components of this item are to be picked
ATP_COMPONENTS_FLAG VARCHAR2 (1) Yes Flag showing if components of item should be checked for ATP
ATP_FLAG VARCHAR2 (1) Yes Flag showing if ATP check is performed for item (item level)
SHIPPABLE_ITEM_FLAG VARCHAR2 (1) Yes Flag showing if item is shippable
MRP_PLANNING_CODE NUMBER

MPR planning option
SO_TRANSACTIONS_FLAG VARCHAR2 (1) Yes Sales order transactions flag
CUSTOMER_ORDER_ENABLED_FLAG VARCHAR2 (1) Yes Flag indicating item is customer orderable
INVOICE_ENABLED_FLAG VARCHAR2 (1) Yes Flag indicating item is invoiceable
INVENTORY_ASSET_FLAG VARCHAR2 (1) Yes Flag indicating item is an inventory asset
ITEM_NUMBER VARCHAR2 (40)
Item name consisting of concatenated item flexfield segments
PADDED_ITEM_NUMBER VARCHAR2 (40)
Item name blank padded to 40 characters
AUTO_REQUEST_MATERIAL VARCHAR2 (1)
Auomatically create move order for the material at work order release
LOOP_FLAG NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TOP_BILL_SEQUENCE_ID
,      BILL_SEQUENCE_ID
,      COMPONENT_SEQUENCE_ID
,      COMPONENT_ITEM_ID
,      ORGANIZATION_ID
,      OPERATION_SEQ_NUM
,      PLAN_LEVEL
,      EXTENDED_QUANTITY
,      ITEM_NUM
,      SORT_ORDER
,      GROUP_ID
,      ITEM_COST
,      RESERVABLE_TYPE
,      EXTEND_COST_FLAG
,      TOP_ALTERNATE_DESIGNATOR
,      TOP_ITEM_ID
,      EFFECTIVITY_DATE
,      DISABLE_DATE
,      IMPLEMENTATION_DATE
,      OPTIONAL
,      PLANNING_FACTOR
,      COMPONENT_YIELD_FACTOR
,      INCLUDE_IN_COST_ROLLUP
,      WIP_SUPPLY_TYPE
,      SUPPLY_SUBINVENTORY
,      SUPPLY_LOCATOR_ID
,      COMPONENT_REMARKS
,      CHANGE_NOTICE
,      BASIS_TYPE
,      COMPONENT_QUANTITY
,      OPERATION_LEAD_TIME_PERCENT
,      MUTUALLY_EXCLUSIVE_OPTIONS
,      CHECK_ATP
,      REQUIRED_TO_SHIP
,      SO_BASIS
,      REQUIRED_FOR_REVENUE
,      INCLUDE_ON_SHIP_DOCS
,      MINIMUM_QUANTITY
,      MAXIMUM_QUANTITY
,      UNIT_OF_MEASURE
,      ITEM_TYPE
,      DESCRIPTION
,      ENG_ITEM_FLAG
,      CUM_MANUFACTURING_LEAD_TIME
,      CUMULATIVE_TOTAL_LEAD_TIME
,      MANUFACTURING_LEAD_TIME
,      PARENT_ITEM_ID
,      PARENT_ALTERNATE
,      ENG_BILL
,      DISPLAY_PLAN_LEVEL
,      EFFECTIVITY_TIME
,      DISABLE_TIME
,      EXTENDED_QUANTITY6
,      EXTENDED_COST
,      OPERATION_SEQ_NUM7
,      BOM_ITEM_TYPE
,      REPLENISH_TO_ORDER_FLAG
,      PICK_COMPONENTS_FLAG
,      ATP_COMPONENTS_FLAG
,      ATP_FLAG
,      SHIPPABLE_ITEM_FLAG
,      MRP_PLANNING_CODE
,      SO_TRANSACTIONS_FLAG
,      CUSTOMER_ORDER_ENABLED_FLAG
,      INVOICE_ENABLED_FLAG
,      INVENTORY_ASSET_FLAG
,      ITEM_NUMBER
,      PADDED_ITEM_NUMBER
,      AUTO_REQUEST_MATERIAL
,      LOOP_FLAG
FROM APPS.BOM_EXPLOSION_VIEW;

Dependencies

[top of page]

APPS.BOM_EXPLOSION_VIEW references the following:

SchemaAPPS
SynonymBOM_EXPLOSION_TEMP
SynonymBOM_STRUCTURES_B
ViewMFG_LOOKUPS
ViewMTL_ITEM_FLEXFIELDS

APPS.BOM_EXPLOSION_VIEW is not referenced by any database object