eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FII_AR_FACTS_AGING_PKG dependencies on DUAL

Line 1107: FROM DUAL

1103: g_fii_user_id, --CREATED_BY,
1104: sysdate, --LAST_UPDATE_DATE,
1105: g_fii_user_id, --LAST_UPDATED_BY,
1106: g_fii_login_id --LAST_UPDATE_LOGIN
1107: FROM DUAL
1108: WHERE NOT EXISTS
1109: (select 1 from fii_change_log
1110: where log_item = 'AR_MAX_PAYMENT_SCHEDULE_ID'));
1111:

Line 1885: FROM DUAL

1881: g_fii_user_id, --CREATED_BY,
1882: sysdate, --LAST_UPDATE_DATE,
1883: g_fii_user_id, --LAST_UPDATED_BY,
1884: g_fii_login_id --LAST_UPDATE_LOGIN
1885: FROM DUAL
1886: WHERE NOT EXISTS
1887: (select 1 from fii_change_log
1888: where log_item = 'AR_MAX_RECEIVABLE_APPLICATION_ID'));
1889:

Line 2055: (SELECT 1 marker FROM DUAL WHERE g_current_bucket_3_low is not null UNION ALL

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
2058: SELECT 4 marker FROM DUAL UNION ALL
2059: SELECT 5 marker FROM DUAL WHERE g_past_due_bucket_2_low is not null UNION ALL

Line 2056: SELECT 2 marker FROM DUAL WHERE g_current_bucket_2_low is not null UNION ALL

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
2058: SELECT 4 marker FROM DUAL UNION ALL
2059: SELECT 5 marker FROM DUAL WHERE g_past_due_bucket_2_low is not null UNION ALL
2060: SELECT 6 marker FROM DUAL WHERE g_past_due_bucket_3_low is not null UNION ALL

Line 2057: SELECT 3 marker FROM DUAL UNION ALL

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
2058: SELECT 4 marker FROM DUAL UNION ALL
2059: SELECT 5 marker FROM DUAL WHERE g_past_due_bucket_2_low is not null UNION ALL
2060: SELECT 6 marker FROM DUAL WHERE g_past_due_bucket_3_low is not null UNION ALL
2061: SELECT 7 marker FROM DUAL WHERE g_past_due_bucket_4_low is not null UNION ALL

Line 2058: SELECT 4 marker FROM DUAL UNION ALL

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
2058: SELECT 4 marker FROM DUAL UNION ALL
2059: SELECT 5 marker FROM DUAL WHERE g_past_due_bucket_2_low is not null UNION ALL
2060: SELECT 6 marker FROM DUAL WHERE g_past_due_bucket_3_low is not null UNION ALL
2061: SELECT 7 marker FROM DUAL WHERE g_past_due_bucket_4_low is not null UNION ALL
2062: SELECT 8 marker FROM DUAL WHERE g_past_due_bucket_5_low is not null UNION ALL

Line 2059: SELECT 5 marker FROM DUAL WHERE g_past_due_bucket_2_low is not null UNION ALL

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
2058: SELECT 4 marker FROM DUAL UNION ALL
2059: SELECT 5 marker FROM DUAL WHERE g_past_due_bucket_2_low is not null UNION ALL
2060: SELECT 6 marker FROM DUAL WHERE g_past_due_bucket_3_low is not null UNION ALL
2061: SELECT 7 marker FROM DUAL WHERE g_past_due_bucket_4_low is not null UNION ALL
2062: SELECT 8 marker FROM DUAL WHERE g_past_due_bucket_5_low is not null UNION ALL
2063: SELECT 9 marker FROM DUAL WHERE g_past_due_bucket_6_low is not null UNION ALL

Line 2060: SELECT 6 marker FROM DUAL WHERE g_past_due_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
2058: SELECT 4 marker FROM DUAL UNION ALL
2059: SELECT 5 marker FROM DUAL WHERE g_past_due_bucket_2_low is not null UNION ALL
2060: SELECT 6 marker FROM DUAL WHERE g_past_due_bucket_3_low is not null UNION ALL
2061: SELECT 7 marker FROM DUAL WHERE g_past_due_bucket_4_low is not null UNION ALL
2062: SELECT 8 marker FROM DUAL WHERE g_past_due_bucket_5_low is not null UNION ALL
2063: SELECT 9 marker FROM DUAL WHERE g_past_due_bucket_6_low is not null UNION ALL
2064: SELECT 10 marker FROM DUAL WHERE g_past_due_bucket_7_low is not null);

Line 2061: SELECT 7 marker FROM DUAL WHERE g_past_due_bucket_4_low is not null UNION ALL

2057: SELECT 3 marker FROM DUAL UNION ALL
2058: SELECT 4 marker FROM DUAL UNION ALL
2059: SELECT 5 marker FROM DUAL WHERE g_past_due_bucket_2_low is not null UNION ALL
2060: SELECT 6 marker FROM DUAL WHERE g_past_due_bucket_3_low is not null UNION ALL
2061: SELECT 7 marker FROM DUAL WHERE g_past_due_bucket_4_low is not null UNION ALL
2062: SELECT 8 marker FROM DUAL WHERE g_past_due_bucket_5_low is not null UNION ALL
2063: SELECT 9 marker FROM DUAL WHERE g_past_due_bucket_6_low is not null UNION ALL
2064: SELECT 10 marker FROM DUAL WHERE g_past_due_bucket_7_low is not null);
2065:

Line 2062: SELECT 8 marker FROM DUAL WHERE g_past_due_bucket_5_low is not null UNION ALL

2058: SELECT 4 marker FROM DUAL UNION ALL
2059: SELECT 5 marker FROM DUAL WHERE g_past_due_bucket_2_low is not null UNION ALL
2060: SELECT 6 marker FROM DUAL WHERE g_past_due_bucket_3_low is not null UNION ALL
2061: SELECT 7 marker FROM DUAL WHERE g_past_due_bucket_4_low is not null UNION ALL
2062: SELECT 8 marker FROM DUAL WHERE g_past_due_bucket_5_low is not null UNION ALL
2063: SELECT 9 marker FROM DUAL WHERE g_past_due_bucket_6_low is not null UNION ALL
2064: SELECT 10 marker FROM DUAL WHERE g_past_due_bucket_7_low is not null);
2065:
2066: g_state := 'Populating FII_AR_AGING_RECEIVABLES';

Line 2063: SELECT 9 marker FROM DUAL WHERE g_past_due_bucket_6_low is not null UNION ALL

2059: SELECT 5 marker FROM DUAL WHERE g_past_due_bucket_2_low is not null UNION ALL
2060: SELECT 6 marker FROM DUAL WHERE g_past_due_bucket_3_low is not null UNION ALL
2061: SELECT 7 marker FROM DUAL WHERE g_past_due_bucket_4_low is not null UNION ALL
2062: SELECT 8 marker FROM DUAL WHERE g_past_due_bucket_5_low is not null UNION ALL
2063: SELECT 9 marker FROM DUAL WHERE g_past_due_bucket_6_low is not null UNION ALL
2064: SELECT 10 marker FROM DUAL WHERE g_past_due_bucket_7_low is not null);
2065:
2066: g_state := 'Populating FII_AR_AGING_RECEIVABLES';
2067: if g_debug_flag = 'Y' then

Line 2064: SELECT 10 marker FROM DUAL WHERE g_past_due_bucket_7_low is not null);

2060: SELECT 6 marker FROM DUAL WHERE g_past_due_bucket_3_low is not null UNION ALL
2061: SELECT 7 marker FROM DUAL WHERE g_past_due_bucket_4_low is not null UNION ALL
2062: SELECT 8 marker FROM DUAL WHERE g_past_due_bucket_5_low is not null UNION ALL
2063: SELECT 9 marker FROM DUAL WHERE g_past_due_bucket_6_low is not null UNION ALL
2064: SELECT 10 marker FROM DUAL WHERE g_past_due_bucket_7_low is not null);
2065:
2066: g_state := 'Populating FII_AR_AGING_RECEIVABLES';
2067: if g_debug_flag = 'Y' then
2068: FII_UTIL.put_line(g_state);

Line 3308: (SELECT 1 marker FROM DUAL UNION ALL

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);
3311:
3312: g_state := 'Populating FII_AR_AGING_RECEIPTS';

Line 3309: SELECT 2 marker FROM DUAL WHERE g_rct_bucket_2_low is not null UNION ALL

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);
3311:
3312: g_state := 'Populating FII_AR_AGING_RECEIPTS';
3313: if g_debug_flag = 'Y' then

Line 3310: SELECT 3 marker FROM DUAL WHERE g_rct_bucket_3_low is not null);

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);
3311:
3312: g_state := 'Populating FII_AR_AGING_RECEIPTS';
3313: if g_debug_flag = 'Y' then
3314: FII_UTIL.put_line(g_state);

Line 3867: (SELECT 1 marker FROM DUAL UNION ALL

3863: dis.payment_schedule_id,
3864: dis.due_date,
3865: dis.actual_date_closed)
3866: where least(end_date, actual_date_closed) <> to_date('12/31/4712','MM/DD/YYYY')) v,
3867: (SELECT 1 marker FROM DUAL UNION ALL
3868: SELECT 2 marker FROM DUAL) m)
3869: WHERE event_date is not null)
3870: /* GROUP BY time_id,
3871: event_date,

Line 3868: SELECT 2 marker FROM DUAL) m)

3864: dis.due_date,
3865: dis.actual_date_closed)
3866: where least(end_date, actual_date_closed) <> to_date('12/31/4712','MM/DD/YYYY')) v,
3867: (SELECT 1 marker FROM DUAL UNION ALL
3868: SELECT 2 marker FROM DUAL) m)
3869: WHERE event_date is not null)
3870: /* GROUP BY time_id,
3871: event_date,
3872: next_aging_date,

Line 3977: FROM dual;

3973: g_fii_user_id, --CREATED_BY,
3974: sysdate, --LAST_UPDATE_DATE,
3975: g_fii_user_id, --LAST_UPDATED_BY,
3976: g_fii_login_id --LAST_UPDATE_LOGIN
3977: FROM dual;
3978:
3979: if g_debug_flag = 'Y' then
3980: FII_UTIL.put_line('Inserted ' ||SQL%ROWCOUNT|| ' records into FII_AR_HELP_MKT_CLASSES');
3981: FII_UTIL.stop_timer;

Line 4254: FROM DUAL

4250: g_fii_user_id, --CREATED_BY,
4251: sysdate, --LAST_UPDATE_DATE,
4252: g_fii_user_id, --LAST_UPDATED_BY,
4253: g_fii_login_id --LAST_UPDATE_LOGIN
4254: FROM DUAL
4255: WHERE NOT EXISTS
4256: (select 1 from fii_change_log
4257: where log_item = 'AR_LAST_UPDATE_DATE'));
4258:

Line 5251: FROM DUAL

5247: g_fii_user_id, --CREATED_BY,
5248: sysdate, --LAST_UPDATE_DATE,
5249: g_fii_user_id, --LAST_UPDATED_BY,
5250: g_fii_login_id --LAST_UPDATE_LOGIN
5251: FROM DUAL
5252: WHERE NOT EXISTS
5253: (select 1 from fii_change_log
5254: where log_item = 'AR_MAX_PAYMENT_SCHEDULE_ID'));
5255:

Line 6684: FROM DUAL

6680: g_fii_user_id, --CREATED_BY,
6681: sysdate, --LAST_UPDATE_DATE,
6682: g_fii_user_id, --LAST_UPDATED_BY,
6683: g_fii_login_id --LAST_UPDATE_LOGIN
6684: FROM DUAL
6685: WHERE NOT EXISTS
6686: (select 1 from fii_change_log
6687: where log_item = 'AR_MAX_RECEIVABLE_APPLICATION_ID'));
6688:

Line 7814: (SELECT 1 marker FROM DUAL WHERE g_current_bucket_3_low is not null UNION ALL

7810: and schdso.dso_type = sch.class
7811: and nvl(adjdso.dso_group,'TC')='TC'
7812: and adj.adj_class = adjdso.dso_type (+)
7813: and adj.customer_trx_id = gt.customer_trx_id) v,
7814: (SELECT 1 marker FROM DUAL WHERE g_current_bucket_3_low is not null UNION ALL
7815: SELECT 2 marker FROM DUAL WHERE g_current_bucket_2_low is not null UNION ALL
7816: SELECT 3 marker FROM DUAL UNION ALL
7817: SELECT 4 marker FROM DUAL UNION ALL
7818: SELECT 5 marker FROM DUAL WHERE g_past_due_bucket_2_low is not null UNION ALL

Line 7815: SELECT 2 marker FROM DUAL WHERE g_current_bucket_2_low is not null UNION ALL

7811: and nvl(adjdso.dso_group,'TC')='TC'
7812: and adj.adj_class = adjdso.dso_type (+)
7813: and adj.customer_trx_id = gt.customer_trx_id) v,
7814: (SELECT 1 marker FROM DUAL WHERE g_current_bucket_3_low is not null UNION ALL
7815: SELECT 2 marker FROM DUAL WHERE g_current_bucket_2_low is not null UNION ALL
7816: SELECT 3 marker FROM DUAL UNION ALL
7817: SELECT 4 marker FROM DUAL UNION ALL
7818: SELECT 5 marker FROM DUAL WHERE g_past_due_bucket_2_low is not null UNION ALL
7819: SELECT 6 marker FROM DUAL WHERE g_past_due_bucket_3_low is not null UNION ALL

Line 7816: SELECT 3 marker FROM DUAL UNION ALL

7812: and adj.adj_class = adjdso.dso_type (+)
7813: and adj.customer_trx_id = gt.customer_trx_id) v,
7814: (SELECT 1 marker FROM DUAL WHERE g_current_bucket_3_low is not null UNION ALL
7815: SELECT 2 marker FROM DUAL WHERE g_current_bucket_2_low is not null UNION ALL
7816: SELECT 3 marker FROM DUAL UNION ALL
7817: SELECT 4 marker FROM DUAL UNION ALL
7818: SELECT 5 marker FROM DUAL WHERE g_past_due_bucket_2_low is not null UNION ALL
7819: SELECT 6 marker FROM DUAL WHERE g_past_due_bucket_3_low is not null UNION ALL
7820: SELECT 7 marker FROM DUAL WHERE g_past_due_bucket_4_low is not null UNION ALL

Line 7817: SELECT 4 marker FROM DUAL UNION ALL

7813: and adj.customer_trx_id = gt.customer_trx_id) v,
7814: (SELECT 1 marker FROM DUAL WHERE g_current_bucket_3_low is not null UNION ALL
7815: SELECT 2 marker FROM DUAL WHERE g_current_bucket_2_low is not null UNION ALL
7816: SELECT 3 marker FROM DUAL UNION ALL
7817: SELECT 4 marker FROM DUAL UNION ALL
7818: SELECT 5 marker FROM DUAL WHERE g_past_due_bucket_2_low is not null UNION ALL
7819: SELECT 6 marker FROM DUAL WHERE g_past_due_bucket_3_low is not null UNION ALL
7820: SELECT 7 marker FROM DUAL WHERE g_past_due_bucket_4_low is not null UNION ALL
7821: SELECT 8 marker FROM DUAL WHERE g_past_due_bucket_5_low is not null UNION ALL

Line 7818: SELECT 5 marker FROM DUAL WHERE g_past_due_bucket_2_low is not null UNION ALL

7814: (SELECT 1 marker FROM DUAL WHERE g_current_bucket_3_low is not null UNION ALL
7815: SELECT 2 marker FROM DUAL WHERE g_current_bucket_2_low is not null UNION ALL
7816: SELECT 3 marker FROM DUAL UNION ALL
7817: SELECT 4 marker FROM DUAL UNION ALL
7818: SELECT 5 marker FROM DUAL WHERE g_past_due_bucket_2_low is not null UNION ALL
7819: SELECT 6 marker FROM DUAL WHERE g_past_due_bucket_3_low is not null UNION ALL
7820: SELECT 7 marker FROM DUAL WHERE g_past_due_bucket_4_low is not null UNION ALL
7821: SELECT 8 marker FROM DUAL WHERE g_past_due_bucket_5_low is not null UNION ALL
7822: SELECT 9 marker FROM DUAL WHERE g_past_due_bucket_6_low is not null UNION ALL

Line 7819: SELECT 6 marker FROM DUAL WHERE g_past_due_bucket_3_low is not null UNION ALL

7815: SELECT 2 marker FROM DUAL WHERE g_current_bucket_2_low is not null UNION ALL
7816: SELECT 3 marker FROM DUAL UNION ALL
7817: SELECT 4 marker FROM DUAL UNION ALL
7818: SELECT 5 marker FROM DUAL WHERE g_past_due_bucket_2_low is not null UNION ALL
7819: SELECT 6 marker FROM DUAL WHERE g_past_due_bucket_3_low is not null UNION ALL
7820: SELECT 7 marker FROM DUAL WHERE g_past_due_bucket_4_low is not null UNION ALL
7821: SELECT 8 marker FROM DUAL WHERE g_past_due_bucket_5_low is not null UNION ALL
7822: SELECT 9 marker FROM DUAL WHERE g_past_due_bucket_6_low is not null UNION ALL
7823: SELECT 10 marker FROM DUAL WHERE g_past_due_bucket_7_low is not null) m)

Line 7820: SELECT 7 marker FROM DUAL WHERE g_past_due_bucket_4_low is not null UNION ALL

7816: SELECT 3 marker FROM DUAL UNION ALL
7817: SELECT 4 marker FROM DUAL UNION ALL
7818: SELECT 5 marker FROM DUAL WHERE g_past_due_bucket_2_low is not null UNION ALL
7819: SELECT 6 marker FROM DUAL WHERE g_past_due_bucket_3_low is not null UNION ALL
7820: SELECT 7 marker FROM DUAL WHERE g_past_due_bucket_4_low is not null UNION ALL
7821: SELECT 8 marker FROM DUAL WHERE g_past_due_bucket_5_low is not null UNION ALL
7822: SELECT 9 marker FROM DUAL WHERE g_past_due_bucket_6_low is not null UNION ALL
7823: SELECT 10 marker FROM DUAL WHERE g_past_due_bucket_7_low is not null) m)
7824: WHERE event_date is not null)

Line 7821: SELECT 8 marker FROM DUAL WHERE g_past_due_bucket_5_low is not null UNION ALL

7817: SELECT 4 marker FROM DUAL UNION ALL
7818: SELECT 5 marker FROM DUAL WHERE g_past_due_bucket_2_low is not null UNION ALL
7819: SELECT 6 marker FROM DUAL WHERE g_past_due_bucket_3_low is not null UNION ALL
7820: SELECT 7 marker FROM DUAL WHERE g_past_due_bucket_4_low is not null UNION ALL
7821: SELECT 8 marker FROM DUAL WHERE g_past_due_bucket_5_low is not null UNION ALL
7822: SELECT 9 marker FROM DUAL WHERE g_past_due_bucket_6_low is not null UNION ALL
7823: SELECT 10 marker FROM DUAL WHERE g_past_due_bucket_7_low is not null) m)
7824: WHERE event_date is not null)
7825: GROUP BY time_id,

Line 7822: SELECT 9 marker FROM DUAL WHERE g_past_due_bucket_6_low is not null UNION ALL

7818: SELECT 5 marker FROM DUAL WHERE g_past_due_bucket_2_low is not null UNION ALL
7819: SELECT 6 marker FROM DUAL WHERE g_past_due_bucket_3_low is not null UNION ALL
7820: SELECT 7 marker FROM DUAL WHERE g_past_due_bucket_4_low is not null UNION ALL
7821: SELECT 8 marker FROM DUAL WHERE g_past_due_bucket_5_low is not null UNION ALL
7822: SELECT 9 marker FROM DUAL WHERE g_past_due_bucket_6_low is not null UNION ALL
7823: SELECT 10 marker FROM DUAL WHERE g_past_due_bucket_7_low is not null) m)
7824: WHERE event_date is not null)
7825: GROUP BY time_id,
7826: time_id_date,

Line 7823: SELECT 10 marker FROM DUAL WHERE g_past_due_bucket_7_low is not null) m)

7819: SELECT 6 marker FROM DUAL WHERE g_past_due_bucket_3_low is not null UNION ALL
7820: SELECT 7 marker FROM DUAL WHERE g_past_due_bucket_4_low is not null UNION ALL
7821: SELECT 8 marker FROM DUAL WHERE g_past_due_bucket_5_low is not null UNION ALL
7822: SELECT 9 marker FROM DUAL WHERE g_past_due_bucket_6_low is not null UNION ALL
7823: SELECT 10 marker FROM DUAL WHERE g_past_due_bucket_7_low is not null) m)
7824: WHERE event_date is not null)
7825: GROUP BY time_id,
7826: time_id_date,
7827: bill_to_customer_id,

Line 8261: (SELECT 1 marker FROM DUAL UNION ALL

8257: and gt.header_status not in ('REV', 'NSF', 'STOP')
8258: and nvl(gt.applied_payment_schedule_id,1) > 0 --exclude all special applications
8259: and gt.application_type = 'CASH'
8260: and gt.amount_applied_rct_func <> 0) v,
8261: (SELECT 1 marker FROM DUAL UNION ALL
8262: SELECT 2 marker FROM DUAL WHERE g_rct_bucket_2_low is not null UNION ALL
8263: SELECT 3 marker FROM DUAL WHERE g_rct_bucket_3_low is not null) m)
8264: WHERE event_date is not null)
8265: GROUP BY time_id,

Line 8262: SELECT 2 marker FROM DUAL WHERE g_rct_bucket_2_low is not null UNION ALL

8258: and nvl(gt.applied_payment_schedule_id,1) > 0 --exclude all special applications
8259: and gt.application_type = 'CASH'
8260: and gt.amount_applied_rct_func <> 0) v,
8261: (SELECT 1 marker FROM DUAL UNION ALL
8262: SELECT 2 marker FROM DUAL WHERE g_rct_bucket_2_low is not null UNION ALL
8263: SELECT 3 marker FROM DUAL WHERE g_rct_bucket_3_low is not null) m)
8264: WHERE event_date is not null)
8265: GROUP BY time_id,
8266: bill_to_customer_id,

Line 8263: SELECT 3 marker FROM DUAL WHERE g_rct_bucket_3_low is not null) m)

8259: and gt.application_type = 'CASH'
8260: and gt.amount_applied_rct_func <> 0) v,
8261: (SELECT 1 marker FROM DUAL UNION ALL
8262: SELECT 2 marker FROM DUAL WHERE g_rct_bucket_2_low is not null UNION ALL
8263: SELECT 3 marker FROM DUAL WHERE g_rct_bucket_3_low is not null) m)
8264: WHERE event_date is not null)
8265: GROUP BY time_id,
8266: bill_to_customer_id,
8267: bill_to_site_use_id,

Line 8365: FROM DUAL

8361: bucket_1_amount_func_MS(i), bucket_1_amount_prim_MS(i), bucket_1_amount_sec_MS(i), bucket_1_count_MS(i),
8362: bucket_2_amount_func_MS(i), bucket_2_amount_prim_MS(i), bucket_2_amount_sec_MS(i), bucket_2_count_MS(i),
8363: bucket_3_amount_func_MS(i), bucket_3_amount_prim_MS(i), bucket_3_amount_sec_MS(i), bucket_3_count_MS(i),
8364: total_unapplied_count_MS(i), sysdate, g_fii_user_id, sysdate, g_fii_user_id, g_fii_login_id
8365: FROM DUAL
8366: WHERE NOT EXISTS
8367: (SELECT 1
8368: FROM fii_ar_aging_receipts ag
8369: WHERE ag.time_id = time_id_MS(i)

Line 8633: (SELECT 1 marker FROM DUAL UNION ALL

8629: dis.payment_schedule_id,
8630: dis.due_date,
8631: dis.actual_date_closed)
8632: where least(end_date, actual_date_closed) <> to_date('12/31/4712','MM/DD/YYYY')) v,
8633: (SELECT 1 marker FROM DUAL UNION ALL
8634: SELECT 2 marker FROM DUAL) m)
8635: WHERE event_date is not null)
8636: /* GROUP BY time_id,
8637: event_date,

Line 8634: SELECT 2 marker FROM DUAL) m)

8630: dis.due_date,
8631: dis.actual_date_closed)
8632: where least(end_date, actual_date_closed) <> to_date('12/31/4712','MM/DD/YYYY')) v,
8633: (SELECT 1 marker FROM DUAL UNION ALL
8634: SELECT 2 marker FROM DUAL) m)
8635: WHERE event_date is not null)
8636: /* GROUP BY time_id,
8637: event_date,
8638: next_aging_date,

Line 9470: FROM DUAL

9466: g_fii_user_id, --CREATED_BY,
9467: sysdate, --LAST_UPDATE_DATE,
9468: g_fii_user_id, --LAST_UPDATED_BY,
9469: g_fii_login_id --LAST_UPDATE_LOGIN
9470: FROM DUAL
9471: WHERE NOT EXISTS
9472: (select 1 from fii_change_log
9473: where log_item = 'AR_LAST_UPDATE_DATE'));
9474: