DBA Data[Home] [Help]

APPS.GMI_MO_PURGE dependencies on IC_TRAN_PND

Line 34: FROM ic_tran_pnd itp

30: and trunc(lines.creation_date) between l_date_from and l_date_to;
31:
32: Cursor Default_transactions (p_line_id VARCHAR2) is
33: SELECT trans_id
34: FROM ic_tran_pnd itp
35: WHERE doc_type = 'OMSO'
36: AND trans_qty = 0
37: AND lot_id = 0
38: AND delete_mark = 0

Line 79: update ic_Tran_pnd

75: LOOP
76: --
77: -- Logically delete the transactions.
78: --
79: update ic_Tran_pnd
80: set delete_mark=1
81: where trans_id= c1rec.trans_id;
82:
83: