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.GME_COMMON_PVT dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 4266: FROM mtl_transaction_lots_temp mtlt,

4262: --FPbug#4912179 query modified to improve performance
4263: CURSOR cur_get_mo_allocations (p_line_id NUMBER)
4264: IS
4265: SELECT mtlt.*
4266: FROM mtl_transaction_lots_temp mtlt,
4267: mtl_material_transactions_temp mmtt
4268: WHERE mmtt.move_order_line_id = p_line_id
4269: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id;
4270: /*SELECT mtlt.*

Line 4272: ,mtl_transaction_lots_temp mtlt

4268: WHERE mmtt.move_order_line_id = p_line_id
4269: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id;
4270: /*SELECT mtlt.*
4271: FROM mtl_txn_request_lines mtrl
4272: ,mtl_transaction_lots_temp mtlt
4273: ,mtl_material_transactions_temp mmtt
4274: WHERE mtrl.line_id = p_line_id
4275: AND mtrl.txn_source_line_id = p_material_detail_id
4276: AND mtrl.line_id = mmtt.move_order_line_id

Line 4289: TYPE l_mo_line_allocations_tbl_typ IS TABLE OF mtl_transaction_lots_temp%ROWTYPE

4285:
4286: TYPE l_mo_lines_tbl_typ IS TABLE OF mtl_txn_request_lines%ROWTYPE
4287: INDEX BY BINARY_INTEGER;
4288:
4289: TYPE l_mo_line_allocations_tbl_typ IS TABLE OF mtl_transaction_lots_temp%ROWTYPE
4290: INDEX BY BINARY_INTEGER;
4291:
4292: --Bug#5590100 Begin
4293: --l_mo_lines_tbl l_mo_lines_tbl_typ; commented the existing line