APPS.FLM_COPY_ROUTING dependencies on BOM_OPERATIONAL_ROUTINGS

Line 216: bom_operational_routings bor, mtl_system_items_kfv msi_kfv

212: bor.assembly_item_id,
213: bor.common_assembly_item_id,
214: bor.alternate_routing_designator
215: From
216: bom_operational_routings bor, mtl_system_items_kfv msi_kfv
217: Where
218: bor.organization_id = p_organization_id
219: and bor.organization_id = msi_kfv.organization_id
220: and bor.assembly_item_id = msi_kfv.inventory_item_id

Line 255: bom_operational_routings bor, mtl_system_items_kfv msi_kfv

251: bor.assembly_item_id,
252: bor.common_assembly_item_id,
253: bor.alternate_routing_designator
254: From
255: bom_operational_routings bor, mtl_system_items_kfv msi_kfv
256: Where
257: bor.organization_id = p_organization_id
258: and bor.organization_id = msi_kfv.organization_id
259: and bor.assembly_item_id = msi_kfv.inventory_item_id

Line 344: bom_operational_routings_v

340: ,NULL Return_Status
341: ,NULL Delete_Group_Name
342: ,NULL DG_Description
343: From
344: bom_operational_routings_v
345: Where
346: routing_sequence_id = p_routing_sequence_id
347: ;
348: l_routing_header_rec c_routing_header%ROWTYPE;

Line 545: bom_operational_routings

541: Cursor c_new_rtg_seq_id(p_item_id number, p_org_id number, p_alternate varchar2) Is
542: Select
543: routing_sequence_id
544: From
545: bom_operational_routings
546: Where
547: assembly_item_id = p_item_id
548: and organization_id = p_org_id
549: and nvl(alternate_routing_designator,'NONE') = nvl(p_alternate,'NONE')

Line 600: from bom_operational_routings bor

596: i := l_rtg_tbl.FIRST;
597: last := l_rtg_tbl.LAST;
598: LOOP
599: select count(*) into dup
600: from bom_operational_routings bor
601: where bor.organization_id = p_organization_id
602: -- and bor.line_id = p_line_id_to
603: and bor.assembly_item_id = l_rtg_tbl(i).assembly_item_id
604: and bor.alternate_routing_designator = p_alternate_code_to;

Line 626: from bom_operational_routings bor

622: j := -1;
623: LOOP
624: if (l_rtg_tbl(i).routing_sequence_id <> l_rtg_tbl(i).common_routing_sequence_id) then
625: select count(*) into dup
626: from bom_operational_routings bor
627: where bor.organization_id = p_organization_id
628: -- and bor.line_id = p_line_id_to
629: and bor.assembly_item_id = l_rtg_tbl(i).common_assembly_item_id
630: and bor.alternate_routing_designator = p_alternate_code_to;

Line 647: from bom_operational_routings

643: if (dup = 0) AND (NOT in_list) then
644: select routing_sequence_id,common_routing_sequence_id,assembly_item_id,
645: common_assembly_item_id,alternate_routing_designator
646: into l_rtg_tbl(j)
647: from bom_operational_routings
648: where routing_sequence_id = l_rtg_tbl(i).common_routing_sequence_id;
649: j := j - 1;
650: end if;
651: end if;