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 29257: FROM bom_small_expl_temp bet

29253: ,bet.sort_order child_sort_order
29254: ,msi.serial_number_control_code serial_number_control_code
29255: ,msi.primary_uom_code primary_uom_code
29256: ,mp.master_organization_id master_organization_id
29257: FROM bom_small_expl_temp bet
29258: ,bom_bill_of_materials bom
29259: ,mtl_system_items msi
29260: ,mtl_system_items msip
29261: ,mtl_parameters mp

Line 29724: DELETE FROM bom_small_expl_temp where group_id = l_group_id;

29720: p_item_tbl := x_ins_tbl;
29721: p_item_relation_tbl := x_rel_tbl;
29722: --
29723: -- Delete records from bom_small_exp_temp
29724: DELETE FROM bom_small_expl_temp where group_id = l_group_id;
29725: --
29726: -- End of API body
29727: -- Standard check of p_commit
29728: IF FND_API.To_Boolean( p_commit ) THEN