[Home] [Help]
MATERIALIZED VIEW: APPS.FII_AR_RCT_AGING_BASE_MV
Source
SELECT time_id,
period_type_id,
parent_party_id,
party_id,
cust_account_id,
collector_id,
org_id,
class_code,
class_category,
grouping_id(time_id,
period_type_id,
parent_party_id,
party_id,
cust_account_id,
collector_id,
org_id,
class_code,
class_category
) gid,
SUM(aging_bucket_1_amount_func) aging_bucket_1_amount_func,
SUM(aging_bucket_1_amount_prim) aging_bucket_1_amount_prim,
SUM(aging_bucket_1_amount_sec) aging_bucket_1_amount_sec,
SUM(aging_bucket_1_count) aging_bucket_1_count,
SUM(aging_bucket_2_amount_func) aging_bucket_2_amount_func,
SUM(aging_bucket_2_amount_prim) aging_bucket_2_amount_prim,
SUM(aging_bucket_2_amount_sec) aging_bucket_2_amount_sec,
SUM(aging_bucket_2_count) aging_bucket_2_count,
SUM(aging_bucket_3_amount_func) aging_bucket_3_amount_func,
SUM(aging_bucket_3_amount_prim) aging_bucket_3_amount_prim,
SUM(aging_bucket_3_amount_sec) aging_bucket_3_amount_sec,
SUM(aging_bucket_3_count) aging_bucket_3_count,
SUM(UNID_amount_func) UNID_amount_func,
SUM(UNID_amount_prim) UNID_amount_prim,
SUM(UNID_amount_sec) UNID_amount_sec,
SUM(UNAPP_amount_func) UNAPP_amount_func,
SUM(UNAPP_amount_prim) UNAPP_amount_prim,
SUM(UNAPP_amount_sec) UNAPP_amount_sec,
SUM(total_unapplied_amount_func) total_unapplied_amount_func,
SUM(total_unapplied_amount_prim) total_unapplied_amount_prim,
SUM(total_unapplied_amount_sec) total_unapplied_amount_sec,
SUM(total_unapplied_count) total_unapplied_count,
COUNT(aging_bucket_1_amount_func) aging_bucket_1_amt_func_ct,
COUNT(aging_bucket_1_amount_prim) aging_bucket_1_amt_prim_ct,
COUNT(aging_bucket_1_amount_sec) aging_bucket_1_amt_sec_ct,
COUNT(aging_bucket_1_count) aging_bucket_1_count_ct,
COUNT(aging_bucket_2_amount_func) aging_bucket_2_amt_func_ct,
COUNT(aging_bucket_2_amt_prim_ct) aging_bucket_2_amt_prim_ct,
COUNT(aging_bucket_2_amt_sec_ct) aging_bucket_2_amt_sec_ct,
COUNT(aging_bucket_2_count_ct) aging_bucket_2_count_ct,
COUNT(aging_bucket_3_amt_func_ct) aging_bucket_3_amt_func_ct,
COUNT(aging_bucket_3_amt_prim_ct) aging_bucket_3_amt_prim_ct,
COUNT(aging_bucket_3_amt_sec_ct) aging_bucket_3_amt_sec_ct,
COUNT(aging_bucket_3_count_ct) aging_bucket_3_count_ct,
COUNT(UNID_amount_func) UNID_amt_func_ct,
COUNT(UNID_amount_prim) UNID_amt_prim_ct,
COUNT(UNID_amount_sec) UNID_amt_sec_ct,
COUNT(UNAPP_amount_func) UNAPP_amt_func_ct,
COUNT(UNID_amount_prim) UNAPP_amt_prim_ct,
COUNT(UNID_amount_sec) UNAPP_amt_sec_ct,
COUNT(total_unapplied_amount_func) total_unapplied_amt_func_ct,
COUNT(total_unapplied_amount_prim) total_unapplied_amt_prim_ct,
COUNT(total_unapplied_amount_sec) total_unapplied_amt_sec_ct,
COUNT(total_unapplied_count) total_unapplied_count_ct,
COUNT(*) ct
FROM APPS.FII_AR_RCT_AGING_INTR_MV
GROUP BY GROUPING SETS(
(org_id,time_id,period_type_id),
(parent_party_id,party_id,cust_account_id,collector_id,org_id,class_code,class_category,time_id,period_type_id)
)