APPS.FII_AR_TPDUE_TBL_REFRESH dependencies on FII_AR_DISPUTES_BASE_MV

Line 99: -- FROM FII_AR_NET_REC_BASE_MV AND FII_AR_DISPUTES_BASE_MV

95: ----------------------------------------------------
96: -- PROCEDURE REFRESH_AR_TPDUE_BASE_F (private)
97: --
98: -- This procedure will (fully) refresh table FII_AR_TPDUE_BASE_F
99: -- FROM FII_AR_NET_REC_BASE_MV AND FII_AR_DISPUTES_BASE_MV
100: ----------------------------------------------------
101: PROCEDURE REFRESH_AR_TPDUE_BASE_F IS
102:
103: l_this_date DATE;

Line 302: --Insert data FROM fii_ar_disputes_base_mv by joining

298: FII_UTIL.print_timer();
299: END IF;
300: commit;
301: --------------------------------------------------------------------------
302: --Insert data FROM fii_ar_disputes_base_mv by joining
303: -- to fii_time_structures, fii_customer_hierarchies, hz_parties
304: --Here we calculate ITD amounts for date on which the job is run
305: --fii_customer_hierarchies and hz_parties is used to avoid
306: --costly GT table population while running the report

Line 370: fii_ar_disputes_base_mv b,

366: past_due_dispute_amount_func,
367: past_due_dispute_amount_prim,
368: past_due_dispute_amount_sec
369: FROM fii_time_structures cal,
370: fii_ar_disputes_base_mv b,
371: FII_CUSTOMER_HIERARCHIES cust,
372: HZ_PARTIES hz
373: WHERE cal.report_date = l_this_date
374: AND cal.time_id = b.time_id

Line 397: FII_UTIL.Write_Log ('FII_AR_TPDUE_BASE_F has been populated from fii_ar_disputes_base_mv successfully');

393:
394:
395: IF g_debug_flag = 'Y' THEN
396: FII_UTIL.stop_timer();
397: FII_UTIL.Write_Log ('FII_AR_TPDUE_BASE_F has been populated from fii_ar_disputes_base_mv successfully');
398: FII_UTIL.Write_Log ('Inserted ' || SQL%ROWCOUNT || ' rows');
399: FII_UTIL.print_timer();
400: END IF;
401: