APPS.WSH_USA_ACTIONS_PVT dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 392: wsh_delivery_assignments wda,

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

Line 431: wsh_delivery_assignments_v wda,

427: SELECT sum(nvl(wdd.requested_quantity, 0))
428: -- muom
429: ,sum(nvl(wdd.requested_quantity2, 0))
430: FROM wsh_delivery_details wdd,
431: wsh_delivery_assignments_v wda,
432: wsh_delivery_details wdd1
433: WHERE wdd.source_code = x_source_code
434: AND wdd.source_line_id = x_original_source_line_id
435: AND wdd.container_flag = 'N'

Line 2072: FROM wsh_delivery_assignments_v wda, wsh_new_deliveries wnd

2068: b_ignore BOOLEAN;
2069:
2070: CURSOR c_get_det_in_del (p_detailid NUMBER) IS
2071: SELECT wnd.name delivery_name
2072: FROM wsh_delivery_assignments_v wda, wsh_new_deliveries wnd
2073: WHERE wda.delivery_id = wnd.delivery_id AND
2074: wda.delivery_id IS NOT NULL AND
2075: wda.delivery_detail_id=p_detailid;
2076: