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

Line 131: MTL_SERIAL_NUMBERS MSN

127: ,0))
128: ,0)
129: INTO V_PRIMARY_SYS_QTY
130: FROM
131: MTL_SERIAL_NUMBERS MSN
132: WHERE MSN.SERIAL_NUMBER = NVL(SERIAL_NUMBER
133: ,SERIAL_NUMBER)
134: AND MSN.INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_V
135: AND MSN.CURRENT_ORGANIZATION_ID = P_ORG_ID

Line 169: MTL_SERIAL_NUMBERS MSN

165: ,'Y'
166: ,'N')
167: INTO V_ISSERIALPRESENT
168: FROM
169: MTL_SERIAL_NUMBERS MSN
170: WHERE MSN.SERIAL_NUMBER = SL_SERIAL_NUMBER
171: AND MSN.INVENTORY_ITEM_ID = INVENTORY_ITEM_ID_V
172: AND MSN.CURRENT_ORGANIZATION_ID = P_ORG_ID
173: AND ( MSN.CURRENT_STATUS = 6