APPS.FLM_AUTO_REPLENISHMENT dependencies on BOM_EXPLOSIONS

Line 257: bom_explosions expl,

253: MIN(comp.component_quantity) component_quantity,
254: MIN(nvl(comp.basis_type,WIP_CONSTANTS.ITEM_BASED_MTL)) basis_type
255: FROM mtl_system_items sys,
256: bom_inventory_components comp,
257: bom_explosions expl,
258: bom_bill_of_materials bbm
259: WHERE bbm.organization_id = sys.organization_id
260: AND comp.component_item_id = sys.inventory_item_id
261: AND comp.component_sequence_id = expl.component_sequence_id

Line 292: FROM bom_explosions

288: GROUP BY expl.component_item_id,comp.operation_seq_num;
289:
290: CURSOR component_sequence_cur IS
291: SELECT component_sequence_id
292: FROM bom_explosions
293: WHERE top_bill_sequence_id = l_top_bill_sequence_id
294: AND explosion_type = 'ALL'
295: AND component_item_id = l_comp_id
296: AND operation_seq_num = l_operation_seq_num

Line 351: FROM bom_explosions

347: l_stmt_no := 120;
348:
349: SELECT max(top_bill_sequence_id)
350: INTO l_top_bill_sequence_id
351: FROM bom_explosions
352: WHERE component_item_id = p_top_assy_id
353: AND organization_id = p_org_id;
354: EXCEPTION
355: WHEN OTHERS THEN

Line 379: -- Retrieve the basis type and component quantity from the bom_explosions table.

375: -- This stores the operation_seq_num from the parent's BOM
376: l_operation_seq_num := comp_record.operation_seq_num;
377:
378: -- Added for Lot Based Material Support
379: -- Retrieve the basis type and component quantity from the bom_explosions table.
380: l_basis_type := comp_record.basis_type;
381: l_qty_per_lot := comp_record.component_quantity;
382:
383: IF l_wip_supply_type = G_Supply_Type_Phantom THEN