DBA Data[Home] [Help]

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 258: Select * From bom_bill_of_materials

254: )
255: Order by bor.routing_sequence_id ;
256:
257: Cursor c_bill_sequence(p_item_id number,p_org_id number,p_alternate varchar2) IS
258: Select * From bom_bill_of_materials
259: Where organization_id = p_org_id
260: and assembly_item_id = p_item_id
261: and (nvl(alternate_bom_designator,'NONE') = nvl(p_alternate,'NONE'));
262: