DBA Data[Home] [Help]

APPS.GMI_PICK_CONFIRM_PUB dependencies on WSH_DELIVERY_DETAILS

Line 115: FROM wsh_delivery_details wsh,

111: WHERE line_id = p_mo_line_id;
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:

Line 138: FROM wsh_delivery_details

134: AND doc_type = 'OMSO'
135: AND line_id = p_line_id
136: AND line_detail_id in (
137: SELECT delivery_detail_id
138: FROM wsh_delivery_details
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(*)