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 CSP_MOVEORDER_LINES

Line 118: csp_moveorder_lines cmol,

114: ,mtrl.quantity_detailed
115: ,mtrl.quantity
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

Line 155: csp_moveorder_lines cmol,

151: ,mtrl.quantity_detailed
152: ,mtrl.quantity
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

Line 192: csp_moveorder_lines cmol,

188: ,mtrl.quantity_detailed
189: ,mtrl.quantity
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

Line 229: csp_moveorder_lines cmol,

225: ,mtrl.quantity_detailed
226: ,mtrl.quantity
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

Line 266: csp_moveorder_lines cmol,

262: ,mtrl.quantity_detailed
263: ,mtrl.quantity
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

Line 366: FROM CSP_MOVEORDER_LINES

362:
363: BEGIN
364: SELECT line_id
365: INTO l_replen_line_id
366: FROM CSP_MOVEORDER_LINES
367: WHERE line_id = mo_replen_rec.line_id;
368: EXCEPTION
369: WHEN NO_DATA_FOUND THEN
370: IF (nvl(l_prev_header_id, 0) <> mo_replen_rec.header_id) THEN