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

Line 120: mtl_txn_request_headers mtrh

116: FROM mtl_item_locations_kfv milk,
117: mtl_system_items_b_kfv msibk,
118: csp_moveorder_lines cmol,
119: mtl_txn_request_lines mtrl,
120: mtl_txn_request_headers mtrh
121: WHERE mtrl.line_status in (3,7)
122: AND mtrl.transaction_type_id = 64 -- Subinventory Transfer = 64, Account Transfer = 63
123: AND ( (p_move_order_type = 1 and mtrh.move_order_type = 1) -- Move Order Requistion
124: OR (p_move_order_type = 2 and mtrh.move_order_type = 2) -- Replenishment Move Orders

Line 157: mtl_txn_request_headers mtrh

153: FROM mtl_item_locations_kfv milk,
154: mtl_system_items_b_kfv msibk,
155: csp_moveorder_lines cmol,
156: mtl_txn_request_lines mtrl,
157: mtl_txn_request_headers mtrh
158: WHERE mtrl.line_status in (3,7)
159: AND mtrl.transaction_type_id = 64 -- Subinventory Transfer = 64, Account Transfer = 63
160: AND ( (p_move_order_type = 1 and mtrh.move_order_type = 1) -- Move Order Requistion
161: OR (p_move_order_type = 2 and mtrh.move_order_type = 2) -- Replenishment Move Orders

Line 194: mtl_txn_request_headers mtrh

190: FROM mtl_item_locations_kfv milk,
191: mtl_system_items_b_kfv msibk,
192: csp_moveorder_lines cmol,
193: mtl_txn_request_lines mtrl,
194: mtl_txn_request_headers mtrh
195: WHERE mtrl.line_status in (3,7)
196: AND mtrl.transaction_type_id = 64 -- Subinventory Transfer = 64, Account Transfer = 63
197: AND ( (p_move_order_type = 1 and mtrh.move_order_type = 1) -- Move Order Requistion
198: OR (p_move_order_type = 2 and mtrh.move_order_type = 2) -- Replenishment Move Orders

Line 231: mtl_txn_request_headers mtrh

227: FROM mtl_item_locations_kfv milk,
228: mtl_system_items_b_kfv msibk,
229: csp_moveorder_lines cmol,
230: mtl_txn_request_lines mtrl,
231: mtl_txn_request_headers mtrh
232: WHERE mtrl.line_status in (3,7)
233: AND mtrl.transaction_type_id = 64 -- Subinventory Transfer = 64, Account Transfer = 63
234: AND ( (p_move_order_type = 1 and mtrh.move_order_type = 1) -- Move Order Requistion
235: OR (p_move_order_type = 2 and mtrh.move_order_type = 2) -- Replenishment Move Orders

Line 268: mtl_txn_request_headers mtrh

264: FROM mtl_item_locations_kfv milk,
265: mtl_system_items_b_kfv msibk,
266: csp_moveorder_lines cmol,
267: mtl_txn_request_lines mtrl,
268: mtl_txn_request_headers mtrh
269: WHERE mtrl.line_status in (3,7)
270: AND mtrl.transaction_type_id = 64 -- Subinventory Transfer = 64, Account Transfer = 63
271: AND ( (p_move_order_type = 1 and mtrh.move_order_type = 1) -- Move Order Requistion
272: OR (p_move_order_type = 2 and mtrh.move_order_type = 2) -- Replenishment Move Orders

Line 312: FROM mtl_txn_request_headers mtrh

308:
309: CURSOR mo_replen_cur IS
310: SELECT mtrl.header_id
311: ,mtrl.line_id
312: FROM mtl_txn_request_headers mtrh
313: ,mtl_txn_request_lines mtrl
314: WHERE mtrl.header_id = mtrh.header_id
315: AND mtrl.line_status = 7
316: AND mtrh.move_order_type = 2