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_SECONDARY_LOCS_INTERFACE

Line 1457: mtl_secondary_locs_interface sli,

1453: prg_appid, /* program_application_id */
1454: prg_id, /* program_id */
1455: SYSDATE /* program_update_date */
1456: from
1457: mtl_secondary_locs_interface sli,
1458: mtl_system_items_interface si
1459: where si.organization_id = sli.organization_id
1460: and si.inventory_item_id = sli.inventory_item_id
1461: and sli.secondary_locator is not NULL

Line 1505: from mtl_secondary_locs_interface sli

1501: mtl_system_items_interface si
1502: where si.organization_id = sl.organization_id
1503: and si.copy_item_id = sl.inventory_item_id
1504: and not exists ( select NULL
1505: from mtl_secondary_locs_interface sli
1506: where sli.inventory_item_id = si.inventory_item_id
1507: and sli.organization_id = si.organization_id
1508: and sli.secondary_locator is not NULL)
1509: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID')));

Line 1643: table_name := 'MTL_SECONDARY_LOCS_INTERFACE';

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'))));
1642:
1643: table_name := 'MTL_SECONDARY_LOCS_INTERFACE';
1644: delete from MTL_SECONDARY_LOCS_INTERFACE li
1645: where li.rowid in ( select li2.rowid
1646: from MTL_SECONDARY_LOCS_INTERFACE li2,
1647: MTL_SYSTEM_ITEMS_INTERFACE si

Line 1644: delete from MTL_SECONDARY_LOCS_INTERFACE li

1640: and si.organization_id = ii2.organization_id
1641: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));
1642:
1643: table_name := 'MTL_SECONDARY_LOCS_INTERFACE';
1644: delete from MTL_SECONDARY_LOCS_INTERFACE li
1645: where li.rowid in ( select li2.rowid
1646: from MTL_SECONDARY_LOCS_INTERFACE li2,
1647: MTL_SYSTEM_ITEMS_INTERFACE si
1648: where si.inventory_item_id = li2.inventory_item_id

Line 1646: from MTL_SECONDARY_LOCS_INTERFACE li2,

1642:
1643: table_name := 'MTL_SECONDARY_LOCS_INTERFACE';
1644: delete from MTL_SECONDARY_LOCS_INTERFACE li
1645: where li.rowid in ( select li2.rowid
1646: from MTL_SECONDARY_LOCS_INTERFACE li2,
1647: MTL_SYSTEM_ITEMS_INTERFACE si
1648: where si.inventory_item_id = li2.inventory_item_id
1649: and si.organization_id = li2.organization_id
1650: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));