APPS.FII_AR_FACTS_AGING_PKG dependencies on FII_AR_MARKER_GT

Line 2050: g_state := 'Truncating table FII_AR_MARKER_GT';

2046: TRUNCATE_TABLE('MLOG$_FII_AR_AGING_RECEIVABLES');
2047: g_state := 'Truncating table FII_AR_AGING_RECEIVABLES';
2048: TRUNCATE_TABLE('FII_AR_AGING_RECEIVABLES');
2049:
2050: g_state := 'Truncating table FII_AR_MARKER_GT';
2051: TRUNCATE_TABLE('FII_AR_MARKER_GT');
2052:
2053: Insert into fii_ar_marker_gt
2054: (marker)

Line 2051: TRUNCATE_TABLE('FII_AR_MARKER_GT');

2047: g_state := 'Truncating table FII_AR_AGING_RECEIVABLES';
2048: TRUNCATE_TABLE('FII_AR_AGING_RECEIVABLES');
2049:
2050: g_state := 'Truncating table FII_AR_MARKER_GT';
2051: TRUNCATE_TABLE('FII_AR_MARKER_GT');
2052:
2053: Insert into fii_ar_marker_gt
2054: (marker)
2055: (SELECT 1 marker FROM DUAL WHERE g_current_bucket_3_low is not null UNION ALL

Line 2053: Insert into fii_ar_marker_gt

2049:
2050: g_state := 'Truncating table FII_AR_MARKER_GT';
2051: TRUNCATE_TABLE('FII_AR_MARKER_GT');
2052:
2053: Insert into fii_ar_marker_gt
2054: (marker)
2055: (SELECT 1 marker FROM DUAL WHERE g_current_bucket_3_low is not null UNION ALL
2056: SELECT 2 marker FROM DUAL WHERE g_current_bucket_2_low is not null UNION ALL
2057: SELECT 3 marker FROM DUAL UNION ALL

Line 3160: fii_ar_marker_gt m)

3156: and schdso.dso_group='TC'
3157: and schdso.dso_type = sch.class
3158: and nvl(adjdso.dso_group,'TC')='TC'
3159: and adj.adj_class = adjdso.dso_type (+) ) v,
3160: fii_ar_marker_gt m)
3161: WHERE event_date is not null)
3162: GROUP BY time_id,
3163: time_id_date,
3164: bill_to_customer_id,

Line 3303: g_state := 'Truncating table FII_AR_MARKER_GT';

3299: TRUNCATE_TABLE('MLOG$_FII_AR_AGING_RECEIPTS');
3300: g_state := 'Truncating table FII_AR_AGING_RECEIPTS';
3301: TRUNCATE_TABLE('FII_AR_AGING_RECEIPTS');
3302:
3303: g_state := 'Truncating table FII_AR_MARKER_GT';
3304: TRUNCATE_TABLE('FII_AR_MARKER_GT');
3305:
3306: Insert into fii_ar_marker_gt
3307: (marker)

Line 3304: TRUNCATE_TABLE('FII_AR_MARKER_GT');

3300: g_state := 'Truncating table FII_AR_AGING_RECEIPTS';
3301: TRUNCATE_TABLE('FII_AR_AGING_RECEIPTS');
3302:
3303: g_state := 'Truncating table FII_AR_MARKER_GT';
3304: TRUNCATE_TABLE('FII_AR_MARKER_GT');
3305:
3306: Insert into fii_ar_marker_gt
3307: (marker)
3308: (SELECT 1 marker FROM DUAL UNION ALL

Line 3306: Insert into fii_ar_marker_gt

3302:
3303: g_state := 'Truncating table FII_AR_MARKER_GT';
3304: TRUNCATE_TABLE('FII_AR_MARKER_GT');
3305:
3306: Insert into fii_ar_marker_gt
3307: (marker)
3308: (SELECT 1 marker FROM DUAL UNION ALL
3309: SELECT 2 marker FROM DUAL WHERE g_rct_bucket_2_low is not null UNION ALL
3310: SELECT 3 marker FROM DUAL WHERE g_rct_bucket_3_low is not null);

Line 3579: from fii_ar_marker_gt t) m)

3575: and nvl(rct.applied_payment_schedule_id,1) > 0 --exclude all special applications
3576: and rct.application_type = 'CASH'
3577: and rct.amount_applied_rct_func <> 0) v,
3578: (select /*+ parallel(t) */ *
3579: from fii_ar_marker_gt t) m)
3580: WHERE event_date is not null)
3581: GROUP BY time_id,
3582: bill_to_customer_id,
3583: bill_to_site_use_id,