VIEW: APPS.BOM_CONSOLIDATE_EXPLOSION_VIEW

Source

View Text - Preformatted

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

View Text - HTML Formatted

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