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 1176: from mtl_serial_numbers

1172: -- API body
1173: begin
1174: select 1
1175: into l_count
1176: from mtl_serial_numbers
1177: where inventory_item_id = p_inventory_item_id
1178: and serial_number = p_serial_number
1179: and rownum <= 1;
1180:

Line 1441: from mtl_serial_numbers

1437: -- API body
1438: begin
1439: select 1,current_status
1440: into l_count,l_current_status
1441: from mtl_serial_numbers
1442: where inventory_item_id = p_inventory_item_id
1443: and serial_number = p_serial_number
1444: and rownum <= 1;
1445:

Line 1767: from mtl_serial_numbers

1763: */
1764:
1765: -- check if serial number exists within asset group
1766: select count(1) into l_count
1767: from mtl_serial_numbers
1768: where inventory_item_id = p_inventory_item_id
1769: and serial_number = p_serial_number;
1770:
1771: if l_count > 0 then

Line 1844: mtl_serial_numbers msn,

1840: cii.instance_number,
1841: cii.inventory_item_id,
1842: msn.gen_object_id
1843: from csi_item_instances cii,
1844: mtl_serial_numbers msn,
1845: fa_additions fa,
1846: csi_i_assets cia,
1847: mtl_system_items msi,
1848: mtl_parameters mp,

Line 1851: mtl_serial_numbers msn_prod,

1847: mtl_system_items msi,
1848: mtl_parameters mp,
1849: eam_org_maint_defaults eomd,
1850: mtl_system_items msi_prod,
1851: mtl_serial_numbers msn_prod,
1852: mtl_parameters mp_prod
1853: where cii.last_vld_organization_id = msn.current_organization_id
1854: and cii.inventory_item_id=msn.inventory_item_id
1855: and cii.serial_number=msn.serial_number