APPS.FLM_COPY_ROUTING dependencies on BOM_OPERATIONAL_ROUTINGS

Line 220: From bom_operational_routings bor, mtl_system_items_kfv msi_kfv

216: bor.common_routing_sequence_id,
217: bor.assembly_item_id,
218: bor.common_assembly_item_id,
219: bor.alternate_routing_designator
220: From bom_operational_routings bor, mtl_system_items_kfv msi_kfv
221: Where bor.organization_id = p_organization_id
222: and bor.organization_id = msi_kfv.organization_id
223: and bor.assembly_item_id = msi_kfv.inventory_item_id
224: and bor.line_id = p_line_id_from

Line 299: From bom_operational_routings_v

295: ,'CREATE' Transaction_Type
296: ,NULL Return_Status
297: ,NULL Delete_Group_Name
298: ,NULL DG_Description
299: From bom_operational_routings_v
300: Where routing_sequence_id = p_routing_sequence_id;
301: l_routing_header_rec c_routing_header%ROWTYPE;
302:
303: Cursor c_routing_revision(p_assembly_item_id number) Is

Line 566: From bom_operational_routings

562: Where standard_operation_id = p_standard_operation_id ;
563:
564: Cursor c_new_rtg_seq_id(p_item_id number, p_org_id number, p_alternate varchar2) Is
565: Select routing_sequence_id
566: From bom_operational_routings
567: Where assembly_item_id = p_item_id
568: and organization_id = p_org_id
569: and nvl(alternate_routing_designator,'NONE') = nvl(p_alternate,'NONE') ;
570:

Line 607: from bom_operational_routings bor

603: i := l_rtg_tbl.FIRST;
604: last := l_rtg_tbl.LAST;
605: LOOP
606: select count(*) into dup
607: from bom_operational_routings bor
608: where bor.organization_id = p_organization_id
609: -- and bor.line_id = p_line_id_to
610: and bor.assembly_item_id = l_rtg_tbl(i).assembly_item_id
611: and bor.alternate_routing_designator = p_alternate_code_to;

Line 633: from bom_operational_routings bor

629: j := -1;
630: LOOP
631: if (l_rtg_tbl(i).routing_sequence_id <> l_rtg_tbl(i).common_routing_sequence_id) then
632: select count(*) into dup
633: from bom_operational_routings bor
634: where bor.organization_id = p_organization_id
635: -- and bor.line_id = p_line_id_to
636: and bor.assembly_item_id = l_rtg_tbl(i).common_assembly_item_id
637: and bor.alternate_routing_designator = p_alternate_code_to;

Line 654: from bom_operational_routings

650: if (dup = 0) AND (NOT in_list) then
651: select routing_sequence_id,common_routing_sequence_id,assembly_item_id,
652: common_assembly_item_id,alternate_routing_designator
653: into l_rtg_tbl(j)
654: from bom_operational_routings
655: where routing_sequence_id = l_rtg_tbl(i).common_routing_sequence_id;
656: j := j - 1;
657: end if;
658: end if;