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_REF_DESGS_INTERFACE

Line 303: from BOM_REF_DESGS_INTERFACE b1,

299: b1.ATTRIBUTE12,
300: b1.ATTRIBUTE13,
301: b1.ATTRIBUTE14,
302: b1.ATTRIBUTE15
303: from BOM_REF_DESGS_INTERFACE b1,
304: BOM_INVENTORY_COMPS_INTERFACE b2,
305: BOM_BILL_OF_MTLS_INTERFACE b3
306: where b1.component_sequence_id = b2.component_sequence_id
307: and b2.bill_sequence_id = b3.bill_sequence_id

Line 1381: table_name := 'BOM_REF_DESGS_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';
1382: delete from BOM_REF_DESGS_INTERFACE b1
1383: where b1.rowid in ( select b.rowid
1384: from BOM_REF_DESGS_INTERFACE b,
1385: BOM_INVENTORY_COMPS_INTERFACE b2,

Line 1382: delete from BOM_REF_DESGS_INTERFACE b1

1378: where b.set_id = TO_CHAR(to_number(USERENV('SESSIONID')));
1379:
1380: stmt_num := 230;
1381: table_name := 'BOM_REF_DESGS_INTERFACE';
1382: delete from BOM_REF_DESGS_INTERFACE b1
1383: where b1.rowid in ( select b.rowid
1384: from BOM_REF_DESGS_INTERFACE b,
1385: BOM_INVENTORY_COMPS_INTERFACE b2,
1386: BOM_BILL_OF_MTLS_INTERFACE b3,

Line 1384: from BOM_REF_DESGS_INTERFACE b,

1380: stmt_num := 230;
1381: table_name := 'BOM_REF_DESGS_INTERFACE';
1382: delete from BOM_REF_DESGS_INTERFACE b1
1383: where b1.rowid in ( select b.rowid
1384: from BOM_REF_DESGS_INTERFACE b,
1385: BOM_INVENTORY_COMPS_INTERFACE b2,
1386: BOM_BILL_OF_MTLS_INTERFACE b3,
1387: MTL_SYSTEM_ITEMS_INTERFACE m
1388: where b.component_sequence_id = b2.component_sequence_id

Line 1766: from BOM_REF_DESGS_INTERFACE

1762: ATTRIBUTE12,
1763: ATTRIBUTE13,
1764: ATTRIBUTE14,
1765: ATTRIBUTE15
1766: from BOM_REF_DESGS_INTERFACE
1767: where process_flag = 4
1768: and rownum < 500;
1769:
1770: EXIT when SQL%NOTFOUND;

Line 1772: update bom_ref_desgs_interface bdi

1768: and rownum < 500;
1769:
1770: EXIT when SQL%NOTFOUND;
1771:
1772: update bom_ref_desgs_interface bdi
1773: set process_flag = 7
1774: where process_flag = 4
1775: and exists (select NULL from bom_reference_designators brd
1776: where brd.component_sequence_id = bdi.component_sequence_id