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_RESOURCES_INTERFACE

Line 796: from BOM_OP_RESOURCES_INTERFACE b1,

792: req_id, /* request_id */
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

Line 1342: ** Remove rows from BOM_OP_RESOURCES_INTERFACE

1338: delete from BOM_BILL_OF_MTLS_INTERFACE b
1339: where b.set_id = TO_CHAR(to_number(USERENV('SESSIONID')));
1340:
1341: /*
1342: ** Remove rows from BOM_OP_RESOURCES_INTERFACE
1343: */
1344: stmt_num := 190;
1345: table_name := 'BOM_OP_RESOURCES_INTERFACE';
1346: delete from BOM_OP_RESOURCES_INTERFACE i

Line 1345: table_name := 'BOM_OP_RESOURCES_INTERFACE';

1341: /*
1342: ** Remove rows from BOM_OP_RESOURCES_INTERFACE
1343: */
1344: stmt_num := 190;
1345: table_name := 'BOM_OP_RESOURCES_INTERFACE';
1346: delete from BOM_OP_RESOURCES_INTERFACE i
1347: where i.rowid in
1348: ( select b1.rowid from
1349: bom_op_resources_interface b1,

Line 1346: delete from BOM_OP_RESOURCES_INTERFACE i

1342: ** Remove rows from BOM_OP_RESOURCES_INTERFACE
1343: */
1344: stmt_num := 190;
1345: table_name := 'BOM_OP_RESOURCES_INTERFACE';
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,

Line 1349: bom_op_resources_interface b1,

1345: table_name := 'BOM_OP_RESOURCES_INTERFACE';
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')))

Line 2266: from BOM_OP_RESOURCES_INTERFACE

2262: REQUEST_ID,
2263: PROGRAM_APPLICATION_ID,
2264: PROGRAM_ID,
2265: PROGRAM_UPDATE_DATE
2266: from BOM_OP_RESOURCES_INTERFACE
2267: where process_flag = 4
2268: and rownum < 500;
2269:
2270: EXIT when SQL%NOTFOUND;

Line 2272: update bom_op_resources_interface bri

2268: and rownum < 500;
2269:
2270: EXIT when SQL%NOTFOUND;
2271:
2272: update bom_op_resources_interface bri
2273: set process_flag = 7
2274: where process_flag = 4
2275: and exists (select NULL from bom_operation_resources bor
2276: where bor.operation_sequence_id =