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.INVPPRCI dependencies on MTL_ITEM_SUB_INVS_INTERFACE

Line 1315: mtl_item_sub_invs_interface isii,

1311: prg_id, /* program_id */
1312: SYSDATE, /* program_update_date */
1313: isii.ENCUMBRANCE_ACCOUNT
1314: from
1315: mtl_item_sub_invs_interface isii,
1316: mtl_system_items_interface si
1317: where si.organization_id = isii.organization_id
1318: and si.inventory_item_id = isii.inventory_item_id
1319: and isii.secondary_inventory is not NULL

Line 1413: from mtl_item_sub_invs_interface isii

1409: mtl_system_items_interface si
1410: where si.organization_id = isi.organization_id
1411: and si.copy_item_id = isi.inventory_item_id
1412: and not exists ( select NULL
1413: from mtl_item_sub_invs_interface isii
1414: where isii.inventory_item_id = si.inventory_item_id
1415: and isii.organization_id = si.organization_id
1416: and isii.secondary_inventory is not NULL
1417: and isii.inventory_planning_code is not NULL)

Line 1634: table_name := 'MTL_ITEM_SUB_INVS_INTERFACE';

1630: where si.inventory_item_id = ri2.inventory_item_id
1631: and si.organization_id = ri2.organization_id
1632: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));
1633:
1634: table_name := 'MTL_ITEM_SUB_INVS_INTERFACE';
1635: delete from MTL_ITEM_SUB_INVS_INTERFACE ii
1636: where ii.rowid in ( select ii2.rowid
1637: from MTL_ITEM_SUB_INVS_INTERFACE ii2,
1638: MTL_SYSTEM_ITEMS_INTERFACE si

Line 1635: delete from MTL_ITEM_SUB_INVS_INTERFACE ii

1631: and si.organization_id = ri2.organization_id
1632: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));
1633:
1634: table_name := 'MTL_ITEM_SUB_INVS_INTERFACE';
1635: delete from MTL_ITEM_SUB_INVS_INTERFACE ii
1636: where ii.rowid in ( select ii2.rowid
1637: from MTL_ITEM_SUB_INVS_INTERFACE ii2,
1638: MTL_SYSTEM_ITEMS_INTERFACE si
1639: where si.inventory_item_id = ii2.inventory_item_id

Line 1637: from MTL_ITEM_SUB_INVS_INTERFACE ii2,

1633:
1634: table_name := 'MTL_ITEM_SUB_INVS_INTERFACE';
1635: delete from MTL_ITEM_SUB_INVS_INTERFACE ii
1636: where ii.rowid in ( select ii2.rowid
1637: from MTL_ITEM_SUB_INVS_INTERFACE ii2,
1638: MTL_SYSTEM_ITEMS_INTERFACE si
1639: where si.inventory_item_id = ii2.inventory_item_id
1640: and si.organization_id = ii2.organization_id
1641: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));