APPS.GMI_PICK_CONFIRM_PUB dependencies on IC_TRAN_PND

Line 129: FROM ic_tran_pnd

125:
126: CURSOR trans_with_no_default_cur(p_line_id NUMBER
127: ,p_mo_line_id NUMBER) IS
128: SELECT count(*)
129: FROM ic_tran_pnd
130: WHERE delete_mark = 0
131: AND completed_ind = 0
132: AND staged_ind = 0
133: AND (lot_id <> 0 OR location <> l_default_loct)

Line 143: FROM ic_tran_pnd

139: WHERE move_order_line_id = p_mo_line_id);
140:
141: CURSOR trans_with_default_cur(p_line_id NUMBER)IS
142: SELECT count(*)
143: FROM ic_tran_pnd
144: WHERE delete_mark = 0
145: AND completed_ind = 0
146: AND staged_ind = 0
147: AND doc_type = 'OMSO'