APPS.CSI_ITEM_INSTANCE_PVT dependencies on BOM_SMALL_EXPL_TEMP

Line 420: FROM bom_small_expl_temp bet

416: CURSOR BOM_CSR (p_group_id NUMBER)
417: IS
418: SELECT bet.component_item_id component_item_id
419: ,mp.master_organization_id master_organization_id
420: FROM bom_small_expl_temp bet
421: ,bom_bill_of_materials bom
422: ,mtl_system_items msi
423: ,mtl_system_items msip
424: ,mtl_parameters mp

Line 492: DELETE FROM bom_small_expl_temp where group_id = l_group_id;

488: End;
489: End Loop;
490: --
491: -- Delete records from bom_small_exp_temp
492: DELETE FROM bom_small_expl_temp where group_id = l_group_id;
493: --
494: IF l_exists_flag = 'Y' THEN
495: l_return_status := TRUE;
496: ELSE

Line 29839: FROM bom_small_expl_temp bet

29835: ,bet.sort_order child_sort_order
29836: ,msi.serial_number_control_code serial_number_control_code
29837: ,msi.primary_uom_code primary_uom_code
29838: ,mp.master_organization_id master_organization_id
29839: FROM bom_small_expl_temp bet
29840: ,bom_bill_of_materials bom
29841: ,mtl_system_items msi
29842: ,mtl_system_items msip
29843: ,mtl_parameters mp

Line 30322: DELETE FROM bom_small_expl_temp where group_id = l_group_id;

30318: p_item_tbl := x_ins_tbl;
30319: p_item_relation_tbl := x_rel_tbl;
30320: --
30321: -- Delete records from bom_small_exp_temp
30322: DELETE FROM bom_small_expl_temp where group_id = l_group_id;
30323: --
30324: -- End of API body
30325: -- Standard check of p_commit
30326: IF FND_API.To_Boolean( p_commit ) THEN