APPS.GML_AUTO_ALLOC dependencies on OP_TRAN_TMP

Line 248: FROM op_tran_tmp

244: sum(loct_onhand) + sum(commit_qty) avail_qty,
245: sum(loct_onhand2) + sum(commit_qty2) avail_qty2,
246: sum(alloc_qty) as alloc_qty, sum(alloc_qty2) as alloc_qty2,
247: trans_id,count(*) numb_trans_line
248: FROM op_tran_tmp
249: WHERE session_id = P_session_id
250: AND item_id = V_item_id
251: AND whse_code = V_whse_code
252: AND expire_date > SYSDATE

Line 323: INSERT INTO op_tran_tmp (session_id, doc_id, line_id, item_id, lot_no, sublot_no,

319: IF X_alloc_qty < 0 THEN
320: RAISE UOM_CONVERSION_ERROR;
321: END IF;
322: /* END IF; */
323: INSERT INTO op_tran_tmp (session_id, doc_id, line_id, item_id, lot_no, sublot_no,
324: lot_id, lot_created, expire_date, qc_grade, whse_code, location,
325: alloc_qty, alloc_qty2)
326: VALUES (P_session_id, 1, 1, V_item_id, LotDetailsRec.lot_no, LotDetailsRec.sublot_no,
327: LotDetailsRec.lot_id, LotDetailsRec.lot_created, LotDetailsRec.expire_date,

Line 367: INSERT INTO op_tran_tmp

363:
364: -- Note that shelf days is taken into account by
365: -- V_trans_date below.
366:
367: INSERT INTO op_tran_tmp
368: (session_id,item_id, line_id, doc_id, lot_no, sublot_no,
369: lot_id, lot_created, expire_date, qc_grade, whse_code, location,
370: loct_onhand, loct_onhand2, commit_qty, commit_qty2, trans_id,
371: id_count, alloc_qty, alloc_qty2 )

Line 391: INSERT INTO op_tran_tmp

387: AND nvl(s.order_proc_ind,1) = 1
388: AND nvl(s.rejected_ind,0) = 0
389: AND b.loct_onhand > 0 ;
390:
391: INSERT INTO op_tran_tmp
392: (session_id,item_id, line_id, doc_id, lot_no, sublot_no,
393: lot_id, lot_created, expire_date, qc_grade, whse_code, location,
394: loct_onhand, loct_onhand2, commit_qty, commit_qty2, trans_id,
395: id_count, alloc_qty, alloc_qty2 )

Line 417: DELETE FROM op_tran_tmp

413: END insert_temp_rows;
414:
415: PROCEDURE clear_table IS
416: BEGIN
417: DELETE FROM op_tran_tmp
418: WHERE session_id = p_session_id;
419: END clear_table;
420:
421: END GML_AUTO_ALLOC;