APPS.BOMPPRCB dependencies on BOM_OPERATIONAL_ROUTINGS

Line 435: table_name := 'BOM_OPERATIONAL_ROUTINGS';

431: /*
432: ** Process routing header interface table
433: */
434: stmt_num := 60;
435: table_name := 'BOM_OPERATIONAL_ROUTINGS';
436: insert into BOM_OPERATIONAL_ROUTINGS
437: (
438: ROUTING_SEQUENCE_ID,
439: ASSEMBLY_ITEM_ID,

Line 436: insert into BOM_OPERATIONAL_ROUTINGS

432: ** Process routing header interface table
433: */
434: stmt_num := 60;
435: table_name := 'BOM_OPERATIONAL_ROUTINGS';
436: insert into BOM_OPERATIONAL_ROUTINGS
437: (
438: ROUTING_SEQUENCE_ID,
439: ASSEMBLY_ITEM_ID,
440: ORGANIZATION_ID,

Line 885: from bom_operational_routings bor,

881: AND bos4.operation_seq_num = bos2.operation_seq_num
882: AND NVL(bos4.operation_type,1) = NVL(bos2.operation_type, 1)
883: AND bos1.routing_sequence_id = ( /* find the model routing */
884: select routing_sequence_id
885: from bom_operational_routings bor,
886: mtl_system_items_interface msi
887: where brif.assembly_item_id = msi.inventory_item_id
888: and brif.organization_id = msi.organization_id
889: and bor.assembly_item_id = msi.copy_item_id

Line 1988: table_name := 'BOM_OPERATIONAL_ROUTINGS';

1984: /*
1985: ** process routing interface table
1986: */
1987: stmt_num := 10;
1988: table_name := 'BOM_OPERATIONAL_ROUTINGS';
1989: loop
1990: insert into BOM_OPERATIONAL_ROUTINGS(
1991: ROUTING_SEQUENCE_ID,
1992: ASSEMBLY_ITEM_ID,

Line 1990: insert into BOM_OPERATIONAL_ROUTINGS(

1986: */
1987: stmt_num := 10;
1988: table_name := 'BOM_OPERATIONAL_ROUTINGS';
1989: loop
1990: insert into BOM_OPERATIONAL_ROUTINGS(
1991: ROUTING_SEQUENCE_ID,
1992: ASSEMBLY_ITEM_ID,
1993: ORGANIZATION_ID,
1994: ALTERNATE_ROUTING_DESIGNATOR,

Line 2072: and exists (select NULL from bom_operational_routings bor

2068:
2069: update bom_op_routings_interface bri
2070: set process_flag = 7
2071: where process_flag = 4
2072: and exists (select NULL from bom_operational_routings bor
2073: where bor.routing_sequence_id =
2074: bri.routing_sequence_id);
2075: commit;
2076: end loop;