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_PICKING_PVT dependencies on MTL_TXN_REQUEST_HEADERS

Line 294: FROM mtl_txn_request_lines l, mtl_txn_request_headers h

290: ,v_batch_id NUMBER
291: ,v_material_detail_id NUMBER)
292: IS
293: SELECT l.line_id, l.header_id
294: FROM mtl_txn_request_lines l, mtl_txn_request_headers h
295: WHERE l.organization_id = v_org_id
296: AND transaction_source_type_id =
297: gme_common_pvt.g_txn_source_type
298: AND l.txn_source_id = v_batch_id

Line 321: FROM mtl_txn_request_lines l, mtl_txn_request_headers h

317: ,v_batch_id NUMBER
318: ,v_material_detail_id NUMBER)
319: IS
320: SELECT count(1)
321: FROM mtl_txn_request_lines l, mtl_txn_request_headers h
322: WHERE l.organization_id = v_org_id
323: AND transaction_source_type_id =
324: gme_common_pvt.g_txn_source_type
325: AND l.txn_source_id = v_batch_id

Line 341: FROM mtl_txn_request_lines l, mtl_txn_request_headers h

337: ,v_batch_id NUMBER
338: ,v_material_detail_id NUMBER)
339: IS
340: SELECT NVL(sum(l.quantity - l.quantity_detailed), 0)
341: FROM mtl_txn_request_lines l, mtl_txn_request_headers h
342: WHERE l.organization_id = v_org_id
343: AND transaction_source_type_id =
344: gme_common_pvt.g_txn_source_type
345: AND l.txn_source_id = v_batch_id