APPS.WSH_DELIVERY_DETAILS_GRP dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 47: wsh_delivery_assignments_v wda

43: wdd.pickable_flag,
44: wda.delivery_id,
45: wda.parent_delivery_detail_id
46: FROM wsh_delivery_details wdd,
47: wsh_delivery_assignments_v wda
48: WHERE wdd.delivery_detail_id = p_detail_id
49: AND wdd.delivery_detail_id = wda.delivery_detail_id;
50:
51:

Line 212: FROM wsh_delivery_assignments_v wda,

208:
209: -- deliveryMerge
210: CURSOR c_get_assigned_delivery (c_delivery_detail_id NUMBER) IS
211: SELECT wda.delivery_id
212: FROM wsh_delivery_assignments_v wda,
213: wsh_delivery_details wdd
214: WHERE wda.delivery_detail_id = c_delivery_detail_id
215: AND wda.delivery_detail_id = wdd.delivery_detail_id
216: AND wdd.container_flag = 'N'

Line 1516: FROM wsh_delivery_assignments_v

1512: )
1513: IS
1514: CURSOR del_assign IS
1515: SELECT delivery_id, parent_delivery_detail_id
1516: FROM wsh_delivery_assignments_v
1517: WHERE delivery_detail_id = p_delivery_detail_id;
1518: l_assign_rec del_assign%ROWTYPE;
1519:
1520: CURSOR del_status(c_del_id NUMBER) IS

Line 2371: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd

2367: -- deliveryMerge
2368:
2369: CURSOR get_delivery(p_del_det_id NUMBER) IS
2370: SELECT wda.delivery_id
2371: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd
2372: WHERE wdd.delivery_detail_id = p_del_det_id
2373: AND wdd.delivery_detail_id = wda.delivery_detail_id
2374: AND wdd.container_flag = 'N'
2375: AND wdd.source_code = 'OE'

Line 4724: FROM wsh_delivery_assignments_v wda

4720:
4721: --
4722: CURSOR det_to_del_cur(p_detail_id NUMBER) IS
4723: SELECT wda.delivery_id
4724: FROM wsh_delivery_assignments_v wda
4725: WHERE wda.delivery_detail_id = p_detail_id;
4726:
4727: -- anxsharm for Load Tender
4728: l_detail_tender_tab wsh_util_core.id_tab_type;

Line 9482: FROM wsh_delivery_assignments_v

9478: --
9479:
9480: CURSOR parent_detail_cur(p_detail_id NUMBER) IS
9481: SELECT parent_delivery_detail_id
9482: FROM wsh_delivery_assignments_v
9483: WHERE delivery_detail_id = p_detail_id;
9484: --
9485: -- HW OPMCONV - Removed OPM variables
9486:

Line 9949: FROM wsh_delivery_assignments_v wda

9945:
9946: --
9947: CURSOR det_to_del_cur(p_detail_id NUMBER) IS
9948: SELECT wda.delivery_id
9949: FROM wsh_delivery_assignments_v wda
9950: WHERE wda.delivery_detail_id = p_detail_id;
9951:
9952: -- anxsharm for Load Tender
9953: l_detail_tender_tab wsh_util_core.id_tab_type;