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.

[Home] [Help]

View: BOM_CONSOLIDATE_EXPLOSION_VIEW

Product:	BOM - Bills of Material
Description:	Consolidated Bill of Material structure for report
Implementation/DBA Data:	APPS.BOM_CONSOLIDATE_EXPLOSION_VIEW

View Text

SELECT GROUP_ID
, TOP_BILL_SEQUENCE_ID
, TOP_ITEM_ID
, TO_NUMBER(NULL)
, ORGANIZATION_ID
, COMPONENT_ITEM_ID
, MAX(SORT_ORDER)
, SUM(EXTENDED_QUANTITY)
, ITEM_COST
, WIP_SUPPLY_TYPE
, TO_NUMBER(NULL)
, BASED_ON_ROLLUP_FLAG
, ACTUAL_COST_TYPE_ID
, SHRINKAGE_RATE
, INVENTORY_ASSET_FLAG
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, EXTEND_COST_FLAG
FROM BOM_EXPLOSION_TEMP GROUP BY GROUP_ID
, TOP_BILL_SEQUENCE_ID
, TOP_ITEM_ID
, ORGANIZATION_ID
, COMPONENT_ITEM_ID
, ITEM_COST
, WIP_SUPPLY_TYPE
, BASED_ON_ROLLUP_FLAG
, ACTUAL_COST_TYPE_ID
, SHRINKAGE_RATE
, INVENTORY_ASSET_FLAG
, EXTEND_COST_FLAG

Columns

Name
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