APPS.INV_PICK_SLIP_REPORT dependencies on MTL_TXN_REQUEST_HEADERS

Line 113: , mtl_txn_request_headers mtrh

109: , mtrl.to_account_id
110: , mtrl.project_id
111: , mtrl.task_id
112: FROM mtl_txn_request_lines mtrl
113: , mtl_txn_request_headers mtrh
114: WHERE mtrl.line_status IN (3, 7)
115: AND mtrh.organization_id = p_org_id
116: AND (p_move_order_from IS NULL OR mtrh.request_number >= p_move_order_from)
117: AND (p_move_order_to IS NULL OR mtrh.request_number <= p_move_order_to)

Line 190: FROM mtl_txn_request_headers mtrh

186:
187: CURSOR c_move_order_header IS
188: SELECT mtrh.header_id
189: , mtrh.move_order_type
190: FROM mtl_txn_request_headers mtrh
191: WHERE mtrh.organization_id = p_org_id
192: AND (p_move_order_from IS NULL OR mtrh.request_number >= p_move_order_from)
193: AND (p_move_order_to IS NULL OR mtrh.request_number <= p_move_order_to)
194: AND ( (p_move_order_type = 99 AND mtrh.move_order_type IN (1,2,3,5))

Line 294: UPDATE mtl_txn_request_headers

290: IF p_pick_slip_group_rule_id IS NOT NULL AND v_mo_line_rec.move_order_type IN (1,2) THEN
291: IF l_debug = 1 THEN
292: mydebug('New Header ID... So updating Pick Slip Grouping Rule', l_api_name);
293: END IF;
294: UPDATE mtl_txn_request_headers
295: SET grouping_rule_id = p_pick_slip_group_rule_id
296: WHERE header_id = v_mo_line_rec.header_id;
297: END IF;
298: END IF;