APPS.WSH_RCV_CORR_RTV_TXN_PKG dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 108: from wsh_delivery_assignments_v wda,

104: -- Finally these deliveries will be used to recalculate the wt-vol,
105: -- and rerating etc.
106: cursor l_delivery_id_csr(p_del_det_id NUMBER) is
107: select wnd.delivery_id
108: from wsh_delivery_assignments_v wda,
109: wsh_new_deliveries wnd
110: where wda.delivery_detail_id = p_del_det_id
111: and wda.delivery_id = wnd.delivery_id;
112:

Line 117: from wsh_delivery_assignments_v

113: --
114: -- cursor to get the lpns for the lines.
115: cursor l_unassigned_lpns_csr(p_delivery_detail_id IN NUMBER) is
116: select parent_delivery_detail_id
117: from wsh_delivery_assignments_v
118: where delivery_detail_id = p_delivery_detail_id;
119:
120: l_unassigned_lpn_id NUMBER;
121:

Line 770: from wsh_delivery_assignments_v wda,

766:
767: -- This is not used any more. Was added in the beginning.
768: cursor l_del_det_fob_chk_csr(p_delivery_id NUMBER) is
769: select 'N'
770: from wsh_delivery_assignments_v wda,
771: wsh_delivery_details wdd1,
772: wsh_delivery_details wdd2
773: where wda.delivery_id = p_delivery_id
774: and wda.delivery_detail_id = wdd1.delivery_detail_id

Line 784: from wsh_delivery_assignments_v wda,

780:
781: -- This is not used any more. Was added in the beginning.
782: cursor l_del_det_fr_terms_chk_csr(p_delivery_id NUMBER) is
783: select 'N'
784: from wsh_delivery_assignments_v wda,
785: wsh_delivery_details wdd1,
786: wsh_delivery_details wdd2
787: where wda.delivery_id = p_delivery_id
788: and wda.delivery_detail_id = wdd1.delivery_detail_id

Line 798: from wsh_delivery_assignments_v wda,

794:
795: -- This is not used any more. Was added in the beginning.
796: cursor l_del_det_fr_term_fob_csr (p_delivery_id NUMBER) is
797: select wdd.freight_terms_code, wdd.fob_code
798: from wsh_delivery_assignments_v wda,
799: wsh_delivery_details wdd
800: where wda.delivery_id = p_delivery_id
801: and wda.delivery_detail_id = wdd.delivery_detail_id
802: and rownum =1;

Line 825: from wsh_delivery_assignments_v

821: -- If they do not have any delivery lines, then
822: -- they are eligible to be deleted.
823: cursor l_chk_lpn_empty_csr(p_del_det_id IN NUMBER) is
824: select 'N'
825: from wsh_delivery_assignments_v
826: where parent_delivery_detail_id = p_del_det_id
827: and rownum=1;
828:
829: l_lpn_empty_flag VARCHAR2(10);

Line 1203: DELETE wsh_delivery_assignments_v

1199:
1200: IF (l_delete_lpn_id_tab.count > 0) THEN
1201: --{
1202: FORALL i IN l_delete_lpn_id_tab.FIRST..l_delete_lpn_id_tab.LAST
1203: DELETE wsh_delivery_assignments_v
1204: WHERE delivery_detail_id = l_delete_lpn_id_tab(i);
1205:
1206: IF l_debug_on THEN
1207: WSH_DEBUG_SV.log(l_module_name,'SQL%ROWCOUNT After deleting LPNs from WDA',SQL%ROWCOUNT);