APPS.WMS_ATF_UTIL_APIS dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 199: FROM mtl_material_transactions_temp

195: transaction_action_id,
196: transaction_source_type_id,
197: parent_line_id,
198: rcv_transaction_id
199: FROM mtl_material_transactions_temp
200: WHERE transaction_header_id = p_txn_header_id
201: AND Nvl(transaction_batch_id, -999) = Nvl(p_txn_batch_id, Nvl(transaction_batch_id, -999))
202: -- AND transaction_temp_id = Nvl(p_transaction_temp_id, transaction_temp_id
203: AND wms_task_type IN (2, -1) -- putaway

Line 217: FROM mtl_material_transactions_temp

213: transaction_action_id,
214: transaction_source_type_id,
215: parent_line_id,
216: rcv_transaction_id
217: FROM mtl_material_transactions_temp
218: -- WHERE transaction_header_id = p_txn_header_id
219: -- AND Nvl(transaction_batch_id, -999) = Nvl(p_txn_batch_id, Nvl(transaction_batch_id, -999))
220: WHERE transaction_temp_id = p_transaction_temp_id
221: AND wms_task_type IN (2, -1) -- putaway

Line 239: FROM mtl_material_transactions_temp

235:
236: CURSOR c_lpns_to_cancel
237: IS
238: SELECT lpn_id, content_lpn_id, transfer_lpn_id
239: FROM mtl_material_transactions_temp
240: WHERE transaction_temp_id = p_transaction_temp_id
241: AND (wms_task_type NOT IN (2, -1)
242: OR wms_task_type IS NULL);
243: l_lpns_to_cancel_rec c_lpns_to_cancel%ROWTYPE;

Line 248: FROM mtl_material_transactions_temp

244:
245: CURSOR c_mmtts_in_lpn(v_lpn_id NUMBER)
246: IS
247: SELECT transaction_temp_id
248: FROM mtl_material_transactions_temp
249: WHERE lpn_id = v_lpn_id
250: AND operation_plan_id IS NOT NULL
251: AND wms_task_type IN (2, -1);
252: