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.PJM_UEFF_ONHAND dependencies on DUAL

Line 216: SELECT X_trx_temp_id FROM dual

212: SELECT count(fm_serial_number)
213: INTO L_trx_qty
214: FROM mtl_serial_numbers_temp msnt
215: WHERE msnt.transaction_temp_id in (
216: SELECT X_trx_temp_id FROM dual
217: UNION ALL
218: SELECT serial_transaction_temp_id
219: FROM mtl_transaction_lots_temp
220: WHERE transaction_temp_id = X_trx_temp_id )

Line 242: SELECT X_trx_temp_id FROM dual

238: INTO L_trx_qty
239: FROM mtl_serial_numbers_temp msnt
240: , mtl_serial_numbers msn
241: WHERE msnt.transaction_temp_id in (
242: SELECT X_trx_temp_id FROM dual
243: UNION ALL
244: SELECT serial_transaction_temp_id
245: FROM mtl_transaction_lots_temp
246: WHERE transaction_temp_id = X_trx_temp_id )