APPS.GMI_OM_ALLOC_API_PUB dependencies on WSH_DELIVERY_DETAILS

Line 150: FROM wsh_delivery_details

146: AND delete_mark <> 1;
147:
148: CURSOR line_detail_id_Cur(p_line_id IN NUMBER) IS
149: SELECT delivery_detail_id,move_order_line_id
150: FROM wsh_delivery_details
151: WHERE source_line_id = p_line_id;
152:
153: CURSOR source_line_id_Cur(p_line_detail_id IN NUMBER) IS
154: SELECT source_line_id

Line 155: FROM wsh_delivery_details

151: WHERE source_line_id = p_line_id;
152:
153: CURSOR source_line_id_Cur(p_line_detail_id IN NUMBER) IS
154: SELECT source_line_id
155: FROM wsh_delivery_details
156: WHERE delivery_detail_id = p_line_detail_id;
157:
158: CURSOR ic_whse_mst_cur(p_organization_id IN NUMBER ) IS
159: SELECT *

Line 242: FROM wsh_delivery_details

238: WHERE trans_id = p_trans_id;
239:
240: CURSOR requested_qty_cur(p_line_detail_id IN NUMBER) IS
241: SELECT requested_quantity,requested_quantity2
242: FROM wsh_delivery_details
243: WHERE delivery_detail_id = p_line_detail_id;
244:
245: CURSOR mo_line_id_cur(p_line_detail_id IN NUMBER) IS
246: SELECT move_order_line_id

Line 247: FROM wsh_delivery_details

243: WHERE delivery_detail_id = p_line_detail_id;
244:
245: CURSOR mo_line_id_cur(p_line_detail_id IN NUMBER) IS
246: SELECT move_order_line_id
247: FROM wsh_delivery_details
248: WHERE delivery_detail_id = p_line_detail_id;
249:
250: /* Some More Variables */
251:

Line 569: ELSE /*If line_detail_id is not passed fetch it from wsh_delivery_details*/

565: END IF;
566:
567: PrintMsg('l_mo_line_id : '||l_mo_line_id);
568:
569: ELSE /*If line_detail_id is not passed fetch it from wsh_delivery_details*/
570:
571: SELECT count(*) into l_count
572: FROM wsh_delivery_details
573: WHERE source_line_id = l_tran_rec.line_id;

Line 572: FROM wsh_delivery_details

568:
569: ELSE /*If line_detail_id is not passed fetch it from wsh_delivery_details*/
570:
571: SELECT count(*) into l_count
572: FROM wsh_delivery_details
573: WHERE source_line_id = l_tran_rec.line_id;
574:
575: /* if there there's more then one line_detail_id */
576: IF ( l_count > 1 )