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.WIP_JSI_DEFAULTER dependencies on MTL_SERIAL_NUMBERS

Line 1814: from mtl_serial_numbers

1810: if(wjsi_row.maintenance_object_type = 1) then
1811: if(wjsi_row.rebuild_item_id is null) then
1812: select gen_object_id
1813: into wjsi_row.maintenance_object_id
1814: from mtl_serial_numbers
1815: where current_organization_id = wjsi_row.organization_id
1816: and inventory_item_id = wjsi_row.asset_group_id
1817: and serial_number = wjsi_row.asset_number;
1818: elsif(wjsi_row.rebuild_serial_number is not null) then

Line 1821: from mtl_serial_numbers

1817: and serial_number = wjsi_row.asset_number;
1818: elsif(wjsi_row.rebuild_serial_number is not null) then
1819: select gen_object_id
1820: into wjsi_row.maintenance_object_id
1821: from mtl_serial_numbers
1822: where current_organization_id = wjsi_row.organization_id
1823: and inventory_item_id = wjsi_row.rebuild_item_id
1824: and serial_number = wjsi_row.rebuild_serial_number;
1825: end if;