APPS.FLM_CREATE_PRODUCT_SYNCH dependencies on BOM_EXPLOSIONS

Line 252: bom_explosions expl,

248: MIN(comp.component_quantity) component_quantity,
249: MIN(nvl(comp.basis_type,WIP_CONSTANTS.ITEM_BASED_MTL)) basis_type
250: from mtl_system_items sys,
251: bom_inventory_components comp,
252: bom_explosions expl,
253: bom_bill_of_materials bbm
254: where sys.planning_make_buy_code = 1
255: and bbm.organization_id = sys.organization_id
256: and comp.component_item_id = sys.inventory_item_id

Line 334: from bom_explosions

330: nvl(arg_alt_bom_desig, '@@@@');
331: l_top_bill_sequence_id := l_bill_sequence_id;
332: select max(top_bill_sequence_id)
333: into l_top_bill_sequence_id
334: from bom_explosions
335: where component_item_id = arg_top_assy_id
336: and organization_id = arg_org_id;
337: EXCEPTION
338: WHEN OTHERS THEN

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

354: -- This stores the operation_seq_num from the parent's BOM
355: var_operation_seq_num := comp_record.operation_seq_num;
356:
357: -- Added to support lot based material
358: -- Retrieve the basis type and component quantity from bom_explosions table.
359: var_basis_type := comp_record.basis_type;
360: var_qty_per_lot := comp_record.component_quantity;
361:
362: if g_debug then