eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOMPPRCB dependencies on BOM_OP_SEQUENCES_INTERFACE

Line 426: from bom_op_sequences_interface

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
426: from bom_op_sequences_interface
427: where routing_sequence_id = l_routing;
428:
429: BEGIN
430:

Line 708: from BOM_OP_SEQUENCES_INTERFACE b,

704: labor_time_user,
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:

Line 797: BOM_OP_SEQUENCES_INTERFACE b2,

793: prg_appid, /* program_application_id */
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')));

Line 1350: BOM_OP_SEQUENCES_INTERFACE b2,

1346: delete from BOM_OP_RESOURCES_INTERFACE i
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);

Line 1358: ** Remove from BOM_OP_SEQUENCES_INTERFACE

1354: and b1.operation_sequence_id = b2.operation_sequence_id);
1355:
1356:
1357: /*
1358: ** Remove from BOM_OP_SEQUENCES_INTERFACE
1359: */
1360: stmt_num := 210;
1361: table_name := 'BOM_OP_SEQUENCES_INTERFACE';
1362: delete from BOM_OP_SEQUENCES_INTERFACE i

Line 1361: table_name := 'BOM_OP_SEQUENCES_INTERFACE';

1357: /*
1358: ** Remove from BOM_OP_SEQUENCES_INTERFACE
1359: */
1360: stmt_num := 210;
1361: table_name := 'BOM_OP_SEQUENCES_INTERFACE';
1362: delete from BOM_OP_SEQUENCES_INTERFACE i
1363: where i.rowid in
1364: ( select b1.rowid from
1365: bom_op_sequences_interface b1,

Line 1362: delete from BOM_OP_SEQUENCES_INTERFACE i

1358: ** Remove from BOM_OP_SEQUENCES_INTERFACE
1359: */
1360: stmt_num := 210;
1361: table_name := 'BOM_OP_SEQUENCES_INTERFACE';
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

Line 1365: bom_op_sequences_interface b1,

1361: table_name := 'BOM_OP_SEQUENCES_INTERFACE';
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:

Line 2166: from BOM_OP_SEQUENCES_INTERFACE

2162: REQUEST_ID,
2163: PROGRAM_APPLICATION_ID,
2164: PROGRAM_ID,
2165: PROGRAM_UPDATE_DATE
2166: from BOM_OP_SEQUENCES_INTERFACE
2167: where process_flag = 4
2168: and rownum < 500;
2169:
2170: EXIT when SQL%NOTFOUND;

Line 2172: update bom_op_sequences_interface bsi

2168: and rownum < 500;
2169:
2170: EXIT when SQL%NOTFOUND;
2171:
2172: update bom_op_sequences_interface bsi
2173: set process_flag = 7
2174: where process_flag = 4
2175: and exists (select NULL from bom_operation_sequences bos
2176: where bos.operation_sequence_id =