APPS.BOMPASGR dependencies on BOM_OPERATIONAL_ROUTINGS

Line 383: bom_operational_routings_s.nextval)

379: loop
380: update bom_op_routings_interface ori
381: set transaction_id = mtl_system_items_interface_s.nextval,
382: routing_sequence_id = nvl(routing_sequence_id,
383: bom_operational_routings_s.nextval)
384: where transaction_id is null
385: and process_flag = 1
386: and rownum < 500;
387: EXIT when SQL%NOTFOUND;

Line 1754: bom_operational_routings bor

1750:
1751: select bor.organization_id
1752: into dummy_org_id
1753: from bom_operation_sequences bos,
1754: bom_operational_routings bor
1755: where operation_sequence_id = c2rec.OSI
1756: and bos.routing_sequence_id = bor.routing_sequence_id;
1757: goto get_resource;
1758: exception

Line 1783: bom_operational_routings bor

1779: begin
1780: select bor.organization_id
1781: into dummy_org_id
1782: from bom_op_sequences_interface bosi,
1783: bom_operational_routings bor
1784: where operation_sequence_id = c2rec.OSI
1785: and bosi.process_flag <> 3 and bosi.process_flag <> 7
1786: and bosi.routing_sequence_id = bor.routing_sequence_id
1787: and rownum = 1;

Line 2126: from bom_operational_routings

2122:
2123: BEGIN
2124: select routing_sequence_id
2125: into rtg_seq_id
2126: from bom_operational_routings
2127: where organization_id = org_id
2128: and assembly_item_id = item_id
2129: and nvl(alternate_routing_designator, 'NONE') =
2130: nvl(alt_desg, 'NONE');

Line 2395: from bom_operational_routings

2391:
2392: BEGIN
2393: select assembly_item_id, organization_id, alternate_routing_designator
2394: into item_id, org_id, alt_desg
2395: from bom_operational_routings
2396: where routing_sequence_id = rtg_seq_id;
2397: return(0);
2398: EXCEPTION
2399: when NO_DATA_FOUND then