APPS.FII_AP_INV_B_C dependencies on AP_DUPLICATE_VENDORS_ALL

Line 2363: FROM AP_Duplicate_Vendors_All

2359:
2360: --Need to handle supplier/supplier site merge during incremental.
2361: g_state := 'Retrieving last supplier or supplier site merge.';
2362: SELECT MAX(Last_Update_Date) INTO l_last_sup_merge
2363: FROM AP_Duplicate_Vendors_All
2364: WHERE Process_Flag = 'Y';
2365:
2366: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_B_L', l_last_start_date,
2367: l_last_end_date, l_last_period_from,

Line 2377: g_state := 'Updating Supplier_ID and Supplier_Site_ID from AP_Duplicate_Vendors_All.';

2373: l_last_period_to);
2374: l_timestamp := greatest(l_timestamp, nvl(l_last_start_date, bis_common_parameters.get_global_start_date));
2375:
2376: IF trunc(l_last_sup_merge) >= trunc(l_timestamp) THEN
2377: g_state := 'Updating Supplier_ID and Supplier_Site_ID from AP_Duplicate_Vendors_All.';
2378:
2379: UPDATE FII_AP_Inv_B BSUM
2380: SET (Supplier_ID, Supplier_Site_ID) =
2381: (SELECT Vendor_ID, NVL(Vendor_Site_ID, Duplicate_Vendor_Site_ID)

Line 2382: FROM AP_Duplicate_Vendors_All DV1

2378:
2379: UPDATE FII_AP_Inv_B BSUM
2380: SET (Supplier_ID, Supplier_Site_ID) =
2381: (SELECT Vendor_ID, NVL(Vendor_Site_ID, Duplicate_Vendor_Site_ID)
2382: FROM AP_Duplicate_Vendors_All DV1
2383: WHERE DV1.Duplicate_Vendor_ID = BSUM.Supplier_ID
2384: AND DV1.Duplicate_Vendor_Site_ID = BSUM.Supplier_Site_ID
2385: AND DV1.Process_Flag = 'Y'
2386: AND TRUNC(DV1.Last_Update_Date) >= TRUNC(l_timestamp))

Line 2389: FROM AP_Duplicate_Vendors_All DV2

2385: AND DV1.Process_Flag = 'Y'
2386: AND TRUNC(DV1.Last_Update_Date) >= TRUNC(l_timestamp))
2387: WHERE (Supplier_ID, Supplier_Site_ID) IN
2388: (SELECT Duplicate_Vendor_ID, Duplicate_Vendor_Site_ID
2389: FROM AP_Duplicate_Vendors_All DV2
2390: WHERE DV2.Process_Flag = 'Y'
2391: AND TRUNC(DV2.Last_Update_Date) >= TRUNC(l_timestamp));
2392:
2393: