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

Line 1170: from mtl_serial_numbers

1166: -- API body
1167: begin
1168: select 1
1169: into l_count
1170: from mtl_serial_numbers
1171: where inventory_item_id = p_inventory_item_id
1172: and serial_number = p_serial_number
1173: and rownum <= 1;
1174:

Line 1433: from mtl_serial_numbers

1429: -- API body
1430: begin
1431: select 1,current_status
1432: into l_count,l_current_status
1433: from mtl_serial_numbers
1434: where inventory_item_id = p_inventory_item_id
1435: and serial_number = p_serial_number
1436: and rownum <= 1;
1437:

Line 1740: from mtl_serial_numbers

1736: */
1737:
1738: -- check if serial number exists within asset group
1739: select count(1) into l_count
1740: from mtl_serial_numbers
1741: where inventory_item_id = p_inventory_item_id
1742: and serial_number = p_serial_number;
1743:
1744: if l_count > 0 then

Line 1817: mtl_serial_numbers msn,

1813: cii.instance_number,
1814: cii.inventory_item_id,
1815: msn.gen_object_id
1816: from csi_item_instances cii,
1817: mtl_serial_numbers msn,
1818: fa_additions fa,
1819: csi_i_assets cia,
1820: mtl_system_items msi,
1821: mtl_parameters mp,

Line 1824: mtl_serial_numbers msn_prod,

1820: mtl_system_items msi,
1821: mtl_parameters mp,
1822: eam_org_maint_defaults eomd,
1823: mtl_system_items msi_prod,
1824: mtl_serial_numbers msn_prod,
1825: mtl_parameters mp_prod
1826: where cii.last_vld_organization_id = msn.current_organization_id
1827: and cii.inventory_item_id=msn.inventory_item_id
1828: and cii.serial_number=msn.serial_number