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.

APPS.BOM_ROLLUP_PUB dependencies on BOM_EXPLOSIONS_ALL

Line 131: --DELETE FROM BOM_EXPLOSIONS_ALL;

127: Procedure Close_ErrorDebug_Handler
128: is
129: BEGIN
130: --Removed for 11.5.10-E
131: --DELETE FROM BOM_EXPLOSIONS_ALL;
132: DELETE FROM BOM_SMALL_IMPL_TEMP;
133:
134: Error_Handler.Close_Debug_Session;
135: END;

Line 642: bom_explosions_all

638: CURSOR l_LowLevelCode_csr is
639: SELECT
640: nvl(max(plan_level), -1) depth
641: FROM
642: bom_explosions_all
643: WHERE
644: group_id = p_rollup_id;
645:
646: l_depth number;

Line 661: bom_explosions_all LLC

657: nvl(UNIT_WEIGHT,0) unit_weight,
658: LLC.assembly_item_id parent_item_id
659: FROM
660: Mtl_System_Items_b MTL,
661: bom_explosions_all LLC
662: WHERE
663: LLC.group_id = p_rollup_id
664: AND LLC.plan_level = p_level
665: AND MTL.INVENTORY_ITEM_ID = LLC.pk1_value

Line 1503: --delete from bom_explosions_all;

1499: );
1500: --if (top_items.structure_type_id is not null) then
1501: l_check_no_bill := false;
1502: --Removed for 11.5.10-E
1503: --delete from bom_explosions_all;
1504: l_rollup_id := to_number(to_char(sysdate,'SSSS'));
1505:
1506:
1507: l_Top_Item_Attrs_Map.DELETE;

Line 1661: --delete from bom_explosions_all;

1657:
1658: FOR top_items in c_Top_Items(p_sequence_id => l_Sequence)
1659: LOOP
1660: --Removed for 11.5.10-E
1661: --delete from bom_explosions_all;
1662: l_rollup_id := to_number(to_char(sysdate,'SSSS'));
1663:
1664:
1665: l_Top_Item_Attrs_Map.DELETE;