APPS.FLM_COPY_ROUTING dependencies on BOM_BILL_OF_MATERIALS

Line 71: from bom_bill_of_materials

67: p_alternate varchar2) Return Boolean Is
68: l_total number := 0;
69: Begin
70: select count(*) into l_total
71: from bom_bill_of_materials
72: where assembly_item_id = p_item_id
73: and organization_id = p_org_id
74: and nvl(alternate_bom_designator,'NONE') = nvl(p_alternate,'NONE');
75:

Line 299: bom_bill_of_materials

295: Cursor c_bill_sequence(p_item_id number,p_org_id number,p_alternate varchar2) IS
296: Select
297: *
298: From
299: bom_bill_of_materials
300: Where
301: organization_id = p_org_id
302: and assembly_item_id = p_item_id
303: and (nvl(alternate_bom_designator,'NONE') = nvl(p_alternate,'NONE'))