APPS.WSH_USA_ACTIONS_PVT dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 390: wsh_delivery_assignments wda,

386: NVL(wda.type, 'S') wda_type,
387: -- END K: MDC
388: wdd.replenishment_status -- bug# 6719369 (replenishment project)
389: FROM wsh_delivery_details wdd,
390: wsh_delivery_assignments wda,
391: wsh_delivery_details wdd1 -- Bug 2773605: Added to fetch parent's lpn_id
392: WHERE wdd.source_code = x_source_code
393: AND wdd.source_line_id = x_original_source_line_id
394: AND wdd.container_flag = 'N'

Line 426: wsh_delivery_assignments_v wda,

422: x_original_source_line_id NUMBER
423: ) IS
424: SELECT sum(nvl(wdd.requested_quantity, 0))
425: FROM wsh_delivery_details wdd,
426: wsh_delivery_assignments_v wda,
427: wsh_delivery_details wdd1
428: WHERE wdd.source_code = x_source_code
429: AND wdd.source_line_id = x_original_source_line_id
430: AND wdd.container_flag = 'N'

Line 1778: FROM wsh_delivery_assignments_v wda, wsh_new_deliveries wnd

1774: b_ignore BOOLEAN;
1775:
1776: CURSOR c_get_det_in_del (p_detailid NUMBER) IS
1777: SELECT wnd.name delivery_name
1778: FROM wsh_delivery_assignments_v wda, wsh_new_deliveries wnd
1779: WHERE wda.delivery_id = wnd.delivery_id AND
1780: wda.delivery_id IS NOT NULL AND
1781: wda.delivery_detail_id=p_detailid;
1782: