APPS.FUN_VENDORMERGE_GRP dependencies on FUN_NET_SUPPLIERS_ALL

Line 121: UPDATE fun_net_suppliers_all s

117: fun_net_util.Log_String(g_event_level,
118: l_path
119: ,'Updating Netting Suppliers');
120:
121: UPDATE fun_net_suppliers_all s
122: SET supplier_id = p_vendor_id,
123: supplier_site_id = decode(supplier_site_id,p_dup_vendor_site_id,
124: p_vendor_site_id, supplier_site_id)
125: WHERE supplier_id = p_dup_vendor_id

Line 134: UPDATE fun_net_suppliers_all s

130: fun_net_util.Log_String(g_event_level
131: ,l_path
132: ,'Rows Updated'|| sql%rowcount);
133:
134: UPDATE fun_net_suppliers_all s
135: SET supplier_priority = (
136: SELECT min(supplier_priority)
137: FROM fun_net_suppliers_all
138: WHERE agreement_id = s.agreement_id

Line 137: FROM fun_net_suppliers_all

133:
134: UPDATE fun_net_suppliers_all s
135: SET supplier_priority = (
136: SELECT min(supplier_priority)
137: FROM fun_net_suppliers_all
138: WHERE agreement_id = s.agreement_id
139: AND supplier_id = s.supplier_id
140: AND nvl(supplier_site_id,0) =
141: decode(s.supplier_site_id,

Line 168: DELETE FROM fun_net_suppliers_all s

164: fun_net_util.Log_String(g_event_level,
165: l_path
166: ,'Deleting Records');
167:
168: DELETE FROM fun_net_suppliers_all s
169: WHERE netting_supplier_id = (SELECT min(netting_supplier_id)
170: FROM fun_net_suppliers_all
171: WHERE
172: s.agreement_id = agreement_id

Line 170: FROM fun_net_suppliers_all

166: ,'Deleting Records');
167:
168: DELETE FROM fun_net_suppliers_all s
169: WHERE netting_supplier_id = (SELECT min(netting_supplier_id)
170: FROM fun_net_suppliers_all
171: WHERE
172: s.agreement_id = agreement_id
173: AND s.supplier_id = supplier_id
174: AND nvl(s.supplier_site_id,0) = nvl(supplier_site_id,0)