APPS.GMI_PICK_CONFIRM_PUB dependencies on IC_TXN_REQUEST_LINES

Line 87: l_mo_line_row ic_txn_request_lines%ROWTYPE;

83:
84:
85: -- Local Variables.
86:
87: l_mo_line_row ic_txn_request_lines%ROWTYPE;
88: l_mo_line_rec GMI_MOVE_ORDER_GLOBAL.mo_line_rec;
89: ll_mo_line_rec GMI_MOVE_ORDER_GLOBAL.mo_line_rec;
90: l_mo_line_tbl GMI_MOVE_ORDER_GLOBAL.mo_line_tbl;
91: -- HW BUG#:3142323

Line 110: FROM ic_txn_request_lines

106: l_warning EXCEPTION;
107:
108: CURSOR move_order_line_cur(p_mo_line_id NUMBER) IS
109: SELECT *
110: FROM ic_txn_request_lines
111: WHERE line_id = p_mo_line_id;
112:
113: CURSOR move_order_line_cur2(p_delivery_detail_id NUMBER) IS
114: SELECT ic.*

Line 116: ic_txn_request_lines ic

112:
113: CURSOR move_order_line_cur2(p_delivery_detail_id NUMBER) IS
114: SELECT ic.*
115: FROM wsh_delivery_details wsh,
116: ic_txn_request_lines ic
117: WHERE ic.line_id = wsh.move_order_line_id
118: AND wsh.delivery_detail_id = p_delivery_detail_id;
119:
120: -- Bug 3274586