DBA Data[Home] [Help]

APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on AP_DUPLICATE_VENDORS_ALL

Line 1526: FROM ap_duplicate_vendors_all

1522: * R12 Perf Bug 4949639 : Do not need this cursor any more
1523: * since we rely on the parameter p_calling_mode
1524: CURSOR check_option IS
1525: SELECT process
1526: FROM ap_duplicate_vendors_all
1527: WHERE vendor_id = p_to_id
1528: AND vendor_site_id = p_to_site_id
1529: AND duplicate_vendor_id = p_from_id
1530: AND duplicate_vendor_site_id = p_from_site_id;

Line 1587: FROM ap_duplicate_vendors_all

1583: AND wdd.ship_from_site_id <> p_to_site_id
1584: AND wdd.vendor_id = p_from_id
1585: AND nvl(wda.type,'S') IN ('S' , 'O')
1586: AND NOT EXISTS (SELECT 1
1587: FROM ap_duplicate_vendors_all
1588: WHERE process_flag IN ('S', 'D')
1589: AND process IN ('P','B')
1590: AND duplicate_vendor_id = wdd.vendor_id
1591: AND duplicate_vendor_site_id = wdd.ship_from_site_id