APPS.BOMPPRCB dependencies on BOM_OP_ROUTINGS_INTERFACE

Line 421: from bom_op_routings_interface b

417: l_routing number;
418:
419: cursor allRoutings is
420: select organization_id, routing_sequence_id,cfm_routing_flag
421: from bom_op_routings_interface b
422: where b.set_id = to_char(to_number(USERENV('SESSIONID')));
423:
424: cursor allops is
425: select operation_sequence_id, model_op_seq_id

Line 522: from BOM_OP_ROUTINGS_INTERFACE b

518: mixed_model_map_flag,
519: priority,
520: total_product_cycle_time,
521: ctp_flag
522: from BOM_OP_ROUTINGS_INTERFACE b
523: where b.set_id = TO_CHAR(to_number(USERENV('SESSIONID')));
524:
525: /*
526: ** Process routing revision interface table

Line 592: from bom_op_routings_interface

588: NULL, /* ATTRIBUTE12 */
589: NULL, /* ATTRIBUTE13 */
590: NULL, /* ATTRIBUTE14 */
591: NULL /* ATTRIBUTE15 */
592: from bom_op_routings_interface
593: where set_id = TO_CHAR(to_number(USERENV('SESSIONID')));
594:
595: /*
596: ** Process operation sequences interface table

Line 709: BOM_OP_ROUTINGS_INTERFACE b1

705: machine_time_user,
706: total_time_user,
707: net_planning_percent
708: from BOM_OP_SEQUENCES_INTERFACE b,
709: BOM_OP_ROUTINGS_INTERFACE b1
710: where b.routing_sequence_id = b1.routing_sequence_id
711: and b1.set_id = TO_CHAR(to_number(USERENV('SESSIONID')));
712:
713: /*

Line 798: BOM_OP_ROUTINGS_INTERFACE b3

794: prg_id, /* program_id */
795: SYSDATE /* program_update_date */
796: from BOM_OP_RESOURCES_INTERFACE b1,
797: BOM_OP_SEQUENCES_INTERFACE b2,
798: BOM_OP_ROUTINGS_INTERFACE b3
799: where b2.operation_sequence_id = b1.operation_sequence_id
800: and b2.routing_sequence_id = b3.routing_sequence_id
801: and b3.set_id = TO_CHAR(to_number(USERENV('SESSIONID')));
802:

Line 871: bom_op_routings_interface brif

867: bom_operation_sequences bos1, /* 'from' Ops of model */
868: bom_operation_sequences bos2, /* 'to' Ops of model */
869: bom_operation_sequences bos3, /* 'from' Ops of config */
870: bom_operation_sequences bos4, /* 'to' Ops of config */
871: bom_op_routings_interface brif
872: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
873: AND bon.to_op_seq_id = bos2.operation_sequence_id
874: AND bos1.routing_sequence_id = bos2.routing_sequence_id
875: AND bos3.routing_sequence_id = brif.routing_sequence_id

Line 1351: BOM_OP_ROUTINGS_INTERFACE b3

1347: where i.rowid in
1348: ( select b1.rowid from
1349: bom_op_resources_interface b1,
1350: BOM_OP_SEQUENCES_INTERFACE b2,
1351: BOM_OP_ROUTINGS_INTERFACE b3
1352: where b3.routing_sequence_id = b2.routing_sequence_id
1353: and b3.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
1354: and b1.operation_sequence_id = b2.operation_sequence_id);
1355:

Line 1366: BOM_OP_ROUTINGS_INTERFACE b2

1362: delete from BOM_OP_SEQUENCES_INTERFACE i
1363: where i.rowid in
1364: ( select b1.rowid from
1365: bom_op_sequences_interface b1,
1366: BOM_OP_ROUTINGS_INTERFACE b2
1367: where b2.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
1368: and b1.routing_sequence_id = b2.routing_sequence_id);
1369:
1370:

Line 1372: ** Remove the moved rows from BOM_OP_ROUTINGS_INTERFACE

1368: and b1.routing_sequence_id = b2.routing_sequence_id);
1369:
1370:
1371: /*
1372: ** Remove the moved rows from BOM_OP_ROUTINGS_INTERFACE
1373: */
1374:
1375: stmt_num := 220;
1376: table_name := 'BOM_OP_ROUTINGS_INTERFACE';

Line 1376: table_name := 'BOM_OP_ROUTINGS_INTERFACE';

1372: ** Remove the moved rows from BOM_OP_ROUTINGS_INTERFACE
1373: */
1374:
1375: stmt_num := 220;
1376: table_name := 'BOM_OP_ROUTINGS_INTERFACE';
1377: delete from BOM_OP_ROUTINGS_INTERFACE b
1378: where b.set_id = TO_CHAR(to_number(USERENV('SESSIONID')));
1379:
1380: stmt_num := 230;

Line 1377: delete from BOM_OP_ROUTINGS_INTERFACE b

1373: */
1374:
1375: stmt_num := 220;
1376: table_name := 'BOM_OP_ROUTINGS_INTERFACE';
1377: delete from BOM_OP_ROUTINGS_INTERFACE b
1378: where b.set_id = TO_CHAR(to_number(USERENV('SESSIONID')));
1379:
1380: stmt_num := 230;
1381: table_name := 'BOM_REF_DESGS_INTERFACE';

Line 2063: from BOM_OP_ROUTINGS_INTERFACE

2059: REQUEST_ID,
2060: PROGRAM_APPLICATION_ID,
2061: PROGRAM_ID,
2062: PROGRAM_UPDATE_DATE
2063: from BOM_OP_ROUTINGS_INTERFACE
2064: where process_flag = 4
2065: and rownum < 500;
2066:
2067: EXIT when SQL%NOTFOUND;

Line 2069: update bom_op_routings_interface bri

2065: and rownum < 500;
2066:
2067: EXIT when SQL%NOTFOUND;
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 =