APPS.WSH_IB_UI_RECON_GRP dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 494: wsh_delivery_assignments_v wda,

490: wnd.status_code,
491: wdd.picked_quantity,
492: wdd.shipped_quantity
493: from wsh_delivery_details wdd,
494: wsh_delivery_assignments_v wda,
495: wsh_new_deliveries wnd
496: where wnd.rcv_shipment_header_id = p_shipment_header_id
497: and wnd.delivery_id = wda.delivery_id
498: and wda.delivery_detail_id = wdd.delivery_detail_id

Line 535: wsh_delivery_assignments_v wda

531: cursor l_packed_del_lines_csr(p_source_line_id NUMBER,
532: p_po_line_loc_id NUMBER) is
533: select wdd.delivery_detail_id
534: from wsh_delivery_details wdd,
535: wsh_delivery_assignments_v wda
536: where wdd.source_line_id = p_source_line_id
537: and wdd.container_flag = 'N'
538: and wdd.source_code = 'PO'
539: and wda.delivery_detail_id = wdd.delivery_detail_id

Line 547: wsh_delivery_assignments_v wda,

543: cursor l_del_det_id_csr(p_shipment_header_id NUMBER) is
544: select wdd.po_shipment_line_id,
545: wdd.delivery_detail_id
546: from wsh_delivery_details wdd,
547: wsh_delivery_assignments_v wda,
548: wsh_new_deliveries wnd
549: where wnd.rcv_shipment_header_id = p_shipment_header_id
550: and wnd.delivery_id = wda.delivery_id
551: and wda.delivery_detail_id = wdd.delivery_detail_id

Line 759: DELETE wsh_delivery_assignments_v

755: --{
756: -- We can delete all the open lines for the po line location.
757: -- first deleting the assignments
758: FORALL i IN l_delete_det_tbl.FIRST..l_delete_det_tbl.LAST
759: DELETE wsh_delivery_assignments_v
760: WHERE delivery_detail_id = l_delete_det_tbl(i);
761:
762: IF l_debug_on THEN
763: WSH_DEBUG_SV.log(l_module_name,'SQL%ROWCOUNT After deleting LPNs from WDA',SQL%ROWCOUNT);

Line 778: delete from wsh_delivery_assignments_v

774: --}
775: END IF;
776: l_delete_det_tbl.delete;
777: /*
778: delete from wsh_delivery_assignments_v
779: where delivery_detail_id in
780: (select delivery_detail_id
781: from wsh_delivery_details
782: where source_line_id = l_source_line_id_tab(i)

Line 997: from wsh_delivery_assignments_v wda,

993: last_update_date = sysdate,
994: last_updated_by = fnd_global.user_id,
995: last_update_login = fnd_global.user_id
996: where delivery_detail_id in (select wda.delivery_detail_id
997: from wsh_delivery_assignments_v wda,
998: wsh_new_deliveries wnd
999: where wnd.rcv_shipment_header_id = p_shipment_header_id
1000: and wda.delivery_id = wnd.delivery_id)
1001: and container_flag = 'Y'