APPS.OZF_CUST_FACTS_PVT dependencies on OZF_CUST_FUND_SUMMARY_MV

Line 2806: ozf_cust_fund_summary_mv b,

2802: SELECT NVL(SUM(utilized_amt),0) tot_utilized,
2803: NVL(SUM(earned_amt),0) tot_earned,
2804: NVL(SUM(paid_amt),0) tot_paid
2805: FROM ozf_time_day a,
2806: ozf_cust_fund_summary_mv b,
2807: ozf_res_cust_prod c
2808: WHERE c.resource_id = outer.resource_id
2809: AND a.report_date = outer.report_date
2810: AND a.ent_year_id = b.time_id

Line 2849: ozf_cust_fund_summary_mv b,

2845: SELECT NVL(SUM(utilized_amt),0) tot_utilized,
2846: NVL(SUM(earned_amt),0) tot_earned,
2847: NVL(SUM(paid_amt),0) tot_paid
2848: FROM ozf_time_day a,
2849: ozf_cust_fund_summary_mv b,
2850: ozf_res_cust_prod c
2851: WHERE c.resource_id = outer.resource_id
2852: AND a.report_date = outer.report_date
2853: AND a.ent_year_id = b.time_id

Line 2894: ozf_cust_fund_summary_mv b,

2890: SELECT NVL(SUM(utilized_amt),0) tot_utilized,
2891: NVL(SUM(earned_amt),0) tot_earned,
2892: NVL(SUM(paid_amt),0) tot_paid
2893: FROM ozf_time_day a,
2894: ozf_cust_fund_summary_mv b,
2895: ozf_res_cust_prod c
2896: WHERE c.resource_id = outer.resource_id
2897: AND a.report_date = outer.report_date
2898: AND a.ent_year_id = b.time_id

Line 2933: ozf_cust_fund_summary_mv b,

2929: SELECT NVL(SUM(utilized_amt),0) tot_utilized,
2930: NVL(SUM(earned_amt),0) tot_earned,
2931: NVL(SUM(paid_amt),0) tot_paid
2932: FROM ozf_time_day a,
2933: ozf_cust_fund_summary_mv b,
2934: ozf_res_cust_prod c
2935: WHERE c.resource_id = outer.resource_id
2936: AND a.report_date = outer.report_date
2937: AND a.ent_qtr_id = b.time_id

Line 2976: ozf_cust_fund_summary_mv b,

2972: SELECT NVL(SUM(utilized_amt),0) tot_utilized,
2973: NVL(SUM(earned_amt),0) tot_earned,
2974: NVL(SUM(paid_amt),0) tot_paid
2975: FROM ozf_time_day a,
2976: ozf_cust_fund_summary_mv b,
2977: ozf_res_cust_prod c
2978: WHERE c.resource_id = outer.resource_id
2979: AND a.report_date = outer.report_date
2980: AND a.ent_qtr_id = b.time_id

Line 3021: ozf_cust_fund_summary_mv b,

3017: SELECT NVL(SUM(utilized_amt),0) tot_utilized,
3018: NVL(SUM(earned_amt),0) tot_earned,
3019: NVL(SUM(paid_amt),0) tot_paid
3020: FROM ozf_time_day a,
3021: ozf_cust_fund_summary_mv b,
3022: ozf_res_cust_prod c
3023: WHERE c.resource_id = outer.resource_id
3024: AND a.report_date = outer.report_date
3025: AND a.ent_qtr_id = b.time_id

Line 3061: ozf_cust_fund_summary_mv b,

3057: SELECT NVL(SUM(utilized_amt),0) tot_utilized,
3058: NVL(SUM(earned_amt),0) tot_earned,
3059: NVL(SUM(paid_amt),0) tot_paid
3060: FROM ozf_time_day a,
3061: ozf_cust_fund_summary_mv b,
3062: ozf_res_cust_prod c
3063: WHERE c.resource_id = outer.resource_id
3064: AND a.report_date = outer.report_date
3065: AND a.ent_period_id = b.time_id

Line 3104: ozf_cust_fund_summary_mv b,

3100: SELECT NVL(SUM(utilized_amt),0) tot_utilized,
3101: NVL(SUM(earned_amt),0) tot_earned,
3102: NVL(SUM(paid_amt),0) tot_paid
3103: FROM ozf_time_day a,
3104: ozf_cust_fund_summary_mv b,
3105: ozf_res_cust_prod c
3106: WHERE c.resource_id = outer.resource_id
3107: AND a.report_date = outer.report_date
3108: AND a.ent_period_id = b.time_id

Line 3149: ozf_cust_fund_summary_mv b,

3145: SELECT NVL(SUM(utilized_amt),0) tot_utilized,
3146: NVL(SUM(earned_amt),0) tot_earned,
3147: NVL(SUM(paid_amt),0) tot_paid
3148: FROM ozf_time_day a,
3149: ozf_cust_fund_summary_mv b,
3150: ozf_res_cust_prod c
3151: WHERE c.resource_id = outer.resource_id
3152: AND a.report_date = outer.report_date
3153: AND a.ent_period_id = b.time_id

Line 3186: FROM ozf_cust_fund_summary_mv b,

3182: Set (FUND_unpaid)
3183: =
3184: (
3185: SELECT (NVL(SUM(earned_amt),0) - NVL(SUM(paid_amt),0)) tot_unpaid
3186: FROM ozf_cust_fund_summary_mv b,
3187: ozf_res_cust_prod c
3188: WHERE c.resource_id = outer.resource_id
3189: AND b.time_id = -1
3190: AND b.period_type_id = 256

Line 3226: FROM ozf_cust_fund_summary_mv b,

3222: Set (fund_unpaid)
3223: =
3224: (
3225: SELECT (NVL(SUM(earned_amt),0) - NVL(SUM(paid_amt),0)) tot_unpaid
3226: FROM ozf_cust_fund_summary_mv b,
3227: ozf_res_cust_prod c
3228: WHERE c.resource_id = outer.resource_id
3229: AND b.time_id = -1
3230: AND b.period_type_id = 256

Line 3268: FROM ozf_cust_fund_summary_mv b,

3264: Set (fund_unpaid)
3265: =
3266: (
3267: SELECT (NVL(SUM(earned_amt),0) - NVL(SUM(paid_amt),0)) tot_unpaid
3268: FROM ozf_cust_fund_summary_mv b,
3269: ozf_res_cust_prod c
3270: WHERE c.resource_id = outer.resource_id
3271: AND b.time_id = -1
3272: AND b.period_type_id = 256

Line 3308: ozf_cust_fund_summary_mv b,

3304: SELECT NVL(SUM(utilized_amt),0) tot_utilized,
3305: NVL(SUM(earned_amt),0) tot_earned,
3306: NVL(SUM(paid_amt),0) tot_paid
3307: FROM ozf_time_day a,
3308: ozf_cust_fund_summary_mv b,
3309: ozf_res_cust_prod c
3310: WHERE c.resource_id = outer.resource_id
3311: AND a.report_date = outer.report_date
3312: AND a.ent_year_id = b.time_id

Line 3338: ozf_cust_fund_summary_mv b,

3334: SELECT NVL(SUM(utilized_amt),0) tot_utilized,
3335: NVL(SUM(earned_amt),0) tot_earned,
3336: NVL(SUM(paid_amt),0) tot_paid
3337: FROM ozf_time_day a,
3338: ozf_cust_fund_summary_mv b,
3339: ozf_res_cust_prod c
3340: WHERE c.resource_id = outer.resource_id
3341: AND a.report_date = outer.report_date
3342: AND a.ent_qtr_id = b.time_id

Line 3368: ozf_cust_fund_summary_mv b,

3364: SELECT NVL(SUM(utilized_amt),0) tot_utilized,
3365: NVL(SUM(earned_amt),0) tot_earned,
3366: NVL(SUM(paid_amt),0) tot_paid
3367: FROM ozf_time_day a,
3368: ozf_cust_fund_summary_mv b,
3369: ozf_res_cust_prod c
3370: WHERE c.resource_id = outer.resource_id
3371: AND a.report_date = outer.report_date
3372: AND a.ent_period_id = b.time_id

Line 3395: FROM ozf_cust_fund_summary_mv b,

3391: Set (fund_unpaid)
3392: =
3393: (
3394: SELECT (NVL(SUM(earned_amt),0) - NVL(SUM(paid_amt),0)) tot_unpaid
3395: FROM ozf_cust_fund_summary_mv b,
3396: ozf_res_cust_prod c
3397: WHERE c.resource_id = outer.resource_id
3398: AND b.time_id = -1
3399: AND b.period_type_id = 256