eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.BOM_CONSOLIDATE_EXPLOSION_VIEW

Object Details

Object Name:	BOM_CONSOLIDATE_EXPLOSION_VIEW
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BOM.BOM_CONSOLIDATE_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
GROUP_ID	NUMBER			Explosion unique identifier
TOP_BILL_SEQUENCE_ID	NUMBER		Yes	Bill identifier for level 0 item
TOP_ITEM_ID	NUMBER			Identifier for level 0 item
BILL_SEQUENCE_ID	NUMBER			Bill of material unique identifier
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
COMPONENT_ITEM_ID	NUMBER			Component item identifier
SORT_ORDER	VARCHAR2	(2000)		Sort sequence
EXTENDED_QUANTITY	NUMBER			Total quantity of component used in bill
ITEM_COST	NUMBER			Item unit cost
WIP_SUPPLY_TYPE	NUMBER			Supply Type
INCLUDE_IN_ROLLUP_FLAG	NUMBER			Flag to indicate if the component is to be included in cost rollup
BASED_ON_ROLLUP_FLAG	NUMBER			Flag to indicate if item costs are based on rollup
ACTUAL_COST_TYPE_ID	NUMBER			Actual cost type
SHRINKAGE_RATE	NUMBER			Item shrinkage rate
INVENTORY_ASSET_FLAG	NUMBER			Flag indicating item is an inventory asset
PLAN_LEVEL	NUMBER			Level in bill of material
OPERATION_SEQ_NUM	NUMBER			Operation sequence number
COMPONENT_SEQUENCE_ID	NUMBER			Component unique identifier
COMPONENT_YIELD_FACTOR	NUMBER			Factor to multiply component quantity to compute component yield
COMPONENT_QUANTITY	NUMBER			Quantity of component used in bill
EXTEND_COST_FLAG	NUMBER			Flag to indicate if the item cost is to be extended

Query Text

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


SELECT GROUP_ID
,      TOP_BILL_SEQUENCE_ID
,      TOP_ITEM_ID
,      BILL_SEQUENCE_ID
,      ORGANIZATION_ID
,      COMPONENT_ITEM_ID
,      SORT_ORDER
,      EXTENDED_QUANTITY
,      ITEM_COST
,      WIP_SUPPLY_TYPE
,      INCLUDE_IN_ROLLUP_FLAG
,      BASED_ON_ROLLUP_FLAG
,      ACTUAL_COST_TYPE_ID
,      SHRINKAGE_RATE
,      INVENTORY_ASSET_FLAG
,      PLAN_LEVEL
,      OPERATION_SEQ_NUM
,      COMPONENT_SEQUENCE_ID
,      COMPONENT_YIELD_FACTOR
,      COMPONENT_QUANTITY
,      EXTEND_COST_FLAG
FROM APPS.BOM_CONSOLIDATE_EXPLOSION_VIEW;

Dependencies

[top of page]

APPS.BOM_CONSOLIDATE_EXPLOSION_VIEW references the following:

APPS: BOM_EXPLOSION_TEMP

APPS.BOM_CONSOLIDATE_EXPLOSION_VIEW is not referenced by any database object