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_SUB_COMPS_INTERFACE

Line 379: from BOM_SUB_COMPS_INTERFACE b1,

375: req_id, /* request_id */
376: prg_appid, /* program_application_id */
377: prg_id, /* program_id */
378: SYSDATE /* program_update_date */
379: from BOM_SUB_COMPS_INTERFACE b1,
380: BOM_INVENTORY_COMPS_INTERFACE b2,
381: BOM_BILL_OF_MTLS_INTERFACE b3
382: where b1.component_sequence_id = b2.component_sequence_id
383: and b2.bill_sequence_id = b3.bill_sequence_id

Line 1398: table_name := 'BOM_SUB_COMPS_INTERFACE';

1394: and b3.organization_id = m.organization_id
1395: and m.set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));
1396:
1397: stmt_num := 240;
1398: table_name := 'BOM_SUB_COMPS_INTERFACE';
1399: delete from BOM_SUB_COMPS_INTERFACE b1
1400: where b1.rowid in ( select b.rowid
1401: from BOM_SUB_COMPS_INTERFACE b,
1402: BOM_INVENTORY_COMPS_INTERFACE b2,

Line 1399: delete from BOM_SUB_COMPS_INTERFACE b1

1395: and m.set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));
1396:
1397: stmt_num := 240;
1398: table_name := 'BOM_SUB_COMPS_INTERFACE';
1399: delete from BOM_SUB_COMPS_INTERFACE b1
1400: where b1.rowid in ( select b.rowid
1401: from BOM_SUB_COMPS_INTERFACE b,
1402: BOM_INVENTORY_COMPS_INTERFACE b2,
1403: BOM_BILL_OF_MTLS_INTERFACE b3,

Line 1401: from BOM_SUB_COMPS_INTERFACE b,

1397: stmt_num := 240;
1398: table_name := 'BOM_SUB_COMPS_INTERFACE';
1399: delete from BOM_SUB_COMPS_INTERFACE b1
1400: where b1.rowid in ( select b.rowid
1401: from BOM_SUB_COMPS_INTERFACE b,
1402: BOM_INVENTORY_COMPS_INTERFACE b2,
1403: BOM_BILL_OF_MTLS_INTERFACE b3,
1404: MTL_SYSTEM_ITEMS_INTERFACE m
1405: where b.component_sequence_id = b2.component_sequence_id

Line 1851: from BOM_SUB_COMPS_INTERFACE

1847: REQUEST_ID,
1848: PROGRAM_APPLICATION_ID,
1849: PROGRAM_ID ,
1850: PROGRAM_UPDATE_DATE
1851: from BOM_SUB_COMPS_INTERFACE
1852: where process_flag = 4
1853: and rownum < 500;
1854:
1855: EXIT when SQL%NOTFOUND;

Line 1857: update bom_sub_comps_interface bsi

1853: and rownum < 500;
1854:
1855: EXIT when SQL%NOTFOUND;
1856:
1857: update bom_sub_comps_interface bsi
1858: set process_flag = 7
1859: where process_flag = 4
1860: and exists (select NULL from bom_substitute_components bsc
1861: where bsc.component_sequence_id = bsi.component_sequence_id