APPS.FII_AR_TPDUE_TBL_REFRESH dependencies on FII_TIME_STRUCTURES

Line 173: -- to fii_time_structures, fii_customer_hierarchies, hz_parties

169:
170:
171: --------------------------------------------------------------------------
172: --Insert data FROM fii_ar_net_rec_base_mv by joining
173: -- to fii_time_structures, fii_customer_hierarchies, hz_parties
174: --Here we calculate ITD amounts for date on which the job is run
175: --fii_customer_hierarchies and hz_parties is used to avoid
176: --costly GT table population while running the report
177: --------------------------------------------------------------------------

Line 266: FROM fii_time_structures cal,

262: wtd_DDSO_due_num_sec,
263: current_open_amount_func,
264: current_open_amount_prim,
265: current_open_amount_sec
266: FROM fii_time_structures cal,
267: fii_ar_net_rec_base_mv b,
268: FII_CUSTOMER_HIERARCHIES cust,
269: HZ_PARTIES hz
270: WHERE cal.report_date = l_this_date

Line 303: -- to fii_time_structures, fii_customer_hierarchies, hz_parties

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
307: --------------------------------------------------------------------------

Line 369: FROM fii_time_structures cal,

365: cust.child_party_id cust_child_party_id,
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

Line 504: -- to fii_time_structures, fii_customer_hierarchies, hz_parties

500:
501:
502: --------------------------------------------------------------------------
503: --Insert data FROM fii_ar_net_rec_base_mv by joining
504: -- to fii_time_structures, fii_customer_hierarchies, hz_parties
505: --Here we calculate ITD amounts for date on which the job is run
506: --fii_customer_hierarchies and hz_parties is used to avoid
507: --costly GT table population while running the report
508: --------------------------------------------------------------------------

Line 597: FROM fii_time_structures cal,

593: wtd_DDSO_due_num_sec,
594: current_open_amount_func,
595: current_open_amount_prim,
596: current_open_amount_sec
597: FROM fii_time_structures cal,
598: fii_ar_net_rec_agrt_mv b,
599: FII_CUSTOMER_HIERARCHIES cust,
600: HZ_PARTIES hz
601: WHERE cal.report_date = l_this_date

Line 638: -- to fii_time_structures, fii_customer_hierarchies, hz_parties

634: END IF;
635: commit;
636: --------------------------------------------------------------------------
637: --Insert data FROM fii_ar_disputes_agrt_mv by joining
638: -- to fii_time_structures, fii_customer_hierarchies, hz_parties
639: --Here we calculate ITD amounts for date on which the job is run
640: --fii_customer_hierarchies and hz_parties is used to avoid
641: --costly GT table population while running the report
642: --------------------------------------------------------------------------

Line 705: FROM fii_time_structures cal,

701: cust.child_party_id cust_child_party_id,
702: past_due_dispute_amount_func past_due_dispute_amount_func,
703: past_due_dispute_amount_prim past_due_dispute_amount_prim,
704: past_due_dispute_amount_sec past_due_dispute_amount_sec
705: FROM fii_time_structures cal,
706: fii_ar_disputes_agrt_mv b,
707: FII_CUSTOMER_HIERARCHIES cust,
708: HZ_PARTIES hz
709: WHERE cal.report_date = l_this_date