APPS.FLM_AUTO_REPLENISHMENT dependencies on BOM_BILL_OF_MATERIALS

Line 258: bom_bill_of_materials bbm

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
262: AND sys.bom_item_type = 4

Line 273: FROM bom_bill_of_materials bbm1

269: OR
270: (bbm.alternate_bom_designator is null AND
271: NOT EXISTS
272: (SELECT null
273: FROM bom_bill_of_materials bbm1
274: WHERE bbm1.alternate_bom_designator = p_alt_bom_desig
275: AND bbm1.organization_id = bbm.organization_id
276: AND bbm1.assembly_item_id = bbm.assembly_item_id)))
277: AND bbm.common_bill_sequence_id = expl.bill_sequence_id

Line 339: FROM bom_bill_of_materials

335: l_bill_sequence_id := null;
336:
337: SELECT bill_sequence_id
338: INTO l_bill_sequence_id
339: FROM bom_bill_of_materials
340: WHERE organization_id = p_org_id
341: AND assembly_item_id = p_top_assy_id
342: AND nvl(alternate_bom_designator, '@@@@') =
343: nvl(p_alt_bom_desig, '@@@@');