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.OZF_CUST_FACTS_PVT dependencies on OZF_TIME_DAY

Line 242: ozf_time_day c

238: p_period_type_id NUMBER ) IS
239: SELECT NVL(SUM(b.sales),0) tot_sales
240: FROM ozf_time_rpt_struct a,
241: ozf_order_sales_v b,
242: ozf_time_day c
243: WHERE c.report_date = p_report_date
244: AND a.time_id = decode(p_period_type_id,32,c.ent_period_id,
245: 64, c.ent_qtr_id,
246: 128, c.ent_year_id)

Line 568: FROM ozf_time_day a,

564: l_return_status VARCHAR2(1);
565:
566: CURSOR last_day_csr IS
567: SELECT b.end_date
568: FROM ozf_time_day a,
569: ozf_time_ent_period b
570: WHERE a.report_date = p_report_date
571: AND a.ent_period_id = b.ent_period_id;
572:

Line 1013: FROM ozf_time_day

1009: CURSOR period_time_id_csr IS
1010: SELECT ent_period_id,
1011: ent_qtr_id,
1012: ent_year_id
1013: FROM ozf_time_day
1014: WHERE report_date = p_report_date;
1015:
1016: l_current_period_time_id NUMBER;
1017: l_current_qtr_time_id NUMBER;

Line 1233: FROM ozf_time_day

1229: ent_qtr_id,
1230: ozf_time_api_pvt.get_period_name(ent_qtr_id, 64) qtr_name,
1231: ent_year_id,
1232: ozf_time_api_pvt.get_period_name(ent_year_id, 128) year_name
1233: FROM ozf_time_day
1234: WHERE report_date = p_report_date;
1235:
1236: l_kpi_rec_count NUMBER;
1237: l_ent_period_id NUMBER;

Line 1543: FROM ozf_time_day

1539: CURSOR period_time_id_csr IS
1540: SELECT ent_period_id,
1541: ent_qtr_id,
1542: ent_year_id
1543: FROM ozf_time_day
1544: WHERE report_date = p_report_date;
1545:
1546: -- Periods in a Quarter
1547: CURSOR period_id_csr(p_qtr_id NUMBER) IS

Line 1787: FROM ozf_time_day

1783:
1784: CURSOR current_periods_csr IS
1785: SELECT ent_period_id,
1786: ent_qtr_id
1787: FROM ozf_time_day
1788: WHERE report_date = p_report_date;
1789:
1790: CURSOR sales_csr( p_time_id NUMBER,
1791: p_site_use_id NUMBER,

Line 2805: FROM ozf_time_day a,

2801: (
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

Line 2848: FROM ozf_time_day a,

2844: (
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

Line 2893: FROM ozf_time_day a,

2889: (
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

Line 2932: FROM ozf_time_day a,

2928: (
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

Line 2975: FROM ozf_time_day a,

2971: (
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

Line 3020: FROM ozf_time_day a,

3016: (
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

Line 3060: FROM ozf_time_day a,

3056: (
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

Line 3103: FROM ozf_time_day a,

3099: (
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

Line 3148: FROM ozf_time_day a,

3144: (
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

Line 3307: FROM ozf_time_day a,

3303: (
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

Line 3337: FROM ozf_time_day a,

3333: (
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

Line 3367: FROM ozf_time_day a,

3363: (
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

Line 3775: FROM ozf_time_day

3771: --
3772: x_record_type_id := 1;
3773:
3774: SELECT start_date, end_date INTO x_start_date, x_end_date
3775: FROM ozf_time_day
3776: WHERE report_date_julian = p_time_id;
3777: --
3778: END IF;
3779: END get_dates;