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_INVENTORY_COMPS_INTERFACE

Line 226: BOM_INVENTORY_COMPS_INTERFACE b,

222: b.SUPPLY_SUBINVENTORY,
223: b.PICK_COMPONENTS,
224: i.BOM_ITEM_TYPE
225: from MTL_SYSTEM_ITEMS i,
226: BOM_INVENTORY_COMPS_INTERFACE b,
227: BOM_BILL_OF_MTLS_INTERFACE b1
228: where b.bill_sequence_id = b1.bill_sequence_id
229: and b1.organization_id = i.organization_id
230: and b.component_item_id = i.inventory_item_id

Line 304: BOM_INVENTORY_COMPS_INTERFACE b2,

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
308: and b3.set_id = TO_CHAR(to_number(USERENV('SESSIONID')));

Line 380: BOM_INVENTORY_COMPS_INTERFACE b2,

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
384: and b3.set_id = TO_CHAR(to_number(USERENV('SESSIONID')));

Line 1321: ** Remove rows from BOM_INVENTORY_COMPS_INTERFACE

1317: end if;
1318: */
1319: if (status = 1) then
1320: /*
1321: ** Remove rows from BOM_INVENTORY_COMPS_INTERFACE
1322: */
1323: stmt_num := 160;
1324: table_name := 'BOM_INVENTORY_COMPS_INTERFACE';
1325: delete from BOM_INVENTORY_COMPS_INTERFACE i

Line 1324: table_name := 'BOM_INVENTORY_COMPS_INTERFACE';

1320: /*
1321: ** Remove rows from BOM_INVENTORY_COMPS_INTERFACE
1322: */
1323: stmt_num := 160;
1324: table_name := 'BOM_INVENTORY_COMPS_INTERFACE';
1325: delete from BOM_INVENTORY_COMPS_INTERFACE i
1326: where i.rowid in
1327: ( select b1.rowid
1328: from bom_inventory_comps_interface b1,

Line 1325: delete from BOM_INVENTORY_COMPS_INTERFACE i

1321: ** Remove rows from BOM_INVENTORY_COMPS_INTERFACE
1322: */
1323: stmt_num := 160;
1324: table_name := 'BOM_INVENTORY_COMPS_INTERFACE';
1325: delete from BOM_INVENTORY_COMPS_INTERFACE i
1326: where i.rowid in
1327: ( select b1.rowid
1328: from bom_inventory_comps_interface b1,
1329: BOM_BILL_OF_MTLS_INTERFACE b2

Line 1328: from bom_inventory_comps_interface b1,

1324: table_name := 'BOM_INVENTORY_COMPS_INTERFACE';
1325: delete from BOM_INVENTORY_COMPS_INTERFACE i
1326: where i.rowid in
1327: ( select b1.rowid
1328: from bom_inventory_comps_interface b1,
1329: BOM_BILL_OF_MTLS_INTERFACE b2
1330: where b2.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
1331: and b1.bill_sequence_id = b2.bill_sequence_id);
1332:

Line 1385: BOM_INVENTORY_COMPS_INTERFACE b2,

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
1389: and b2.bill_sequence_id = b3.bill_sequence_id

Line 1402: BOM_INVENTORY_COMPS_INTERFACE b2,

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
1406: and b2.bill_sequence_id = b3.bill_sequence_id

Line 1678: from BOM_INVENTORY_COMPS_INTERFACE

1674: WIP_SUPPLY_TYPE,
1675: SUPPLY_LOCATOR_ID,
1676: SUPPLY_SUBINVENTORY,
1677: BOM_ITEM_TYPE
1678: from BOM_INVENTORY_COMPS_INTERFACE
1679: where process_flag = 4
1680: and rownum < 500;
1681:
1682: EXIT when SQL%NOTFOUND;

Line 1684: update bom_inventory_comps_interface bci

1680: and rownum < 500;
1681:
1682: EXIT when SQL%NOTFOUND;
1683:
1684: update bom_inventory_comps_interface bci
1685: set process_flag = 7
1686: where process_flag = 4
1687: and exists (select NULL
1688: from bom_inventory_components bic