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.WMS_PICK_DROP_PVT dependencies on MTL_TXN_REQUEST_HEADERS

Line 116: , mtl_txn_request_headers mtrh

112: ) IS
113: SELECT mtrh.move_order_type
114: , mtrl.line_status
115: FROM mtl_txn_request_lines mtrl
116: , mtl_txn_request_headers mtrh
117: WHERE mtrl.line_id = p_mo_line_id
118: AND mtrl.header_id = mtrh.header_id;
119:
120: l_mo_line_id NUMBER;

Line 870: , mtl_txn_request_headers mtrh

866: )
867: )
868: FROM mtl_material_transactions_temp mmtt
869: , mtl_txn_request_lines mtrl
870: , mtl_txn_request_headers mtrh
871: WHERE mmtt.organization_id = p_org_id
872: --Modified for Bug 6717052
873: AND (mmtt.transfer_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id IN (SELECT wlpn.lpn_id FROM wms_license_plate_numbers wlpn
874: WHERE wlpn.outermost_lpn_id = p_lpn_id))

Line 3408: , mtl_txn_request_headers mtrh

3404: FROM mtl_material_transactions_temp mmtt
3405: , mtl_secondary_inventories msi
3406: , mtl_item_locations mil
3407: , mtl_txn_request_lines mtrl
3408: , mtl_txn_request_headers mtrh
3409: WHERE mmtt.organization_id = p_org_id
3410: AND mmtt.transfer_lpn_id = p_lpn_id
3411: AND mmtt.transaction_action_id = 2
3412: AND ( (mmtt.parent_line_id IS NOT NULL

Line 3452: , mtl_txn_request_headers mtrh

3448: FROM mtl_material_transactions_temp mmtt
3449: , mtl_secondary_inventories msi
3450: , mtl_item_locations mil
3451: , mtl_txn_request_lines mtrl
3452: , mtl_txn_request_headers mtrh
3453: WHERE mmtt.organization_id = p_org_id
3454: AND mmtt.transfer_lpn_id = p_lpn_id
3455: AND mmtt.transaction_action_id = 2
3456: AND ( (mmtt.parent_line_id IS NOT NULL