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 1451: --delete from bom_explosions_all;

1447: );
1448: --if (top_items.structure_type_id is not null) then
1449: l_check_no_bill := false;
1450: --Removed for 11.5.10-E
1451: --delete from bom_explosions_all;
1452: l_rollup_id := to_number(to_char(sysdate,'SSSS'));
1453:
1454:
1455: l_Top_Item_Attrs_Map.DELETE;

Line 1609: --delete from bom_explosions_all;

1605:
1606: FOR top_items in c_Top_Items(p_sequence_id => l_Sequence)
1607: LOOP
1608: --Removed for 11.5.10-E
1609: --delete from bom_explosions_all;
1610: l_rollup_id := to_number(to_char(sysdate,'SSSS'));
1611:
1612:
1613: l_Top_Item_Attrs_Map.DELETE;