APPS.WSH_DELIVERY_DETAILS_GRP dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 51: wsh_delivery_assignments_v wda

47: wv_frozen_flag,
48: wdd.inv_interfaced_flag
49: -- Added for bug 13574503
50: FROM wsh_delivery_details wdd,
51: wsh_delivery_assignments_v wda
52: WHERE wdd.delivery_detail_id = p_detail_id
53: AND wdd.delivery_detail_id = wda.delivery_detail_id;
54:
55:

Line 216: FROM wsh_delivery_assignments_v wda,

212:
213: -- deliveryMerge
214: CURSOR c_get_assigned_delivery (c_delivery_detail_id NUMBER) IS
215: SELECT wda.delivery_id
216: FROM wsh_delivery_assignments_v wda,
217: wsh_delivery_details wdd
218: WHERE wda.delivery_detail_id = c_delivery_detail_id
219: AND wda.delivery_detail_id = wdd.delivery_detail_id
220: AND wdd.container_flag = 'N'

Line 1520: FROM wsh_delivery_assignments_v

1516: )
1517: IS
1518: CURSOR del_assign IS
1519: SELECT delivery_id, parent_delivery_detail_id
1520: FROM wsh_delivery_assignments_v
1521: WHERE delivery_detail_id = p_delivery_detail_id;
1522: l_assign_rec del_assign%ROWTYPE;
1523:
1524: CURSOR del_status(c_del_id NUMBER) IS

Line 2377: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd

2373: -- deliveryMerge
2374:
2375: CURSOR get_delivery(p_del_det_id NUMBER) IS
2376: SELECT wda.delivery_id
2377: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd
2378: WHERE wdd.delivery_detail_id = p_del_det_id
2379: AND wdd.delivery_detail_id = wda.delivery_detail_id
2380: AND wdd.container_flag = 'N'
2381: AND wdd.source_code = 'OE'

Line 4734: FROM wsh_delivery_assignments_v wda

4730:
4731: --
4732: CURSOR det_to_del_cur(p_detail_id NUMBER) IS
4733: SELECT wda.delivery_id
4734: FROM wsh_delivery_assignments_v wda
4735: WHERE wda.delivery_detail_id = p_detail_id;
4736:
4737: -- anxsharm for Load Tender
4738: l_detail_tender_tab wsh_util_core.id_tab_type;

Line 7616: ,wsh_delivery_assignments wda

7612:
7613: CURSOR get_lpn_id IS
7614: SELECT wdd.lpn_id
7615: FROM wsh_delivery_details wdd
7616: ,wsh_delivery_assignments wda
7617: WHERE wdd.delivery_detail_id = wda.parent_delivery_detail_id
7618: AND wda.delivery_detail_id = x_detail_rec.delivery_detail_id
7619: AND wdd.container_flag = 'Y';
7620:

Line 9602: FROM wsh_delivery_assignments_v

9598: --
9599:
9600: CURSOR parent_detail_cur(p_detail_id NUMBER) IS
9601: SELECT parent_delivery_detail_id
9602: FROM wsh_delivery_assignments_v
9603: WHERE delivery_detail_id = p_detail_id;
9604: --
9605: -- HW OPMCONV - Removed OPM variables
9606:

Line 10069: FROM wsh_delivery_assignments_v wda

10065:
10066: --
10067: CURSOR det_to_del_cur(p_detail_id NUMBER) IS
10068: SELECT wda.delivery_id
10069: FROM wsh_delivery_assignments_v wda
10070: WHERE wda.delivery_detail_id = p_detail_id;
10071:
10072: -- anxsharm for Load Tender
10073: l_detail_tender_tab wsh_util_core.id_tab_type;