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_FORECAST_UTIL_PVT dependencies on OZF_ACT_METRIC_FACTS_ALL_S

Line 1695: VALUES ( ozf_act_metric_facts_all_s.nextval , sysdate ,

1691: BASE_QUANTITY , ROOT_FACT_ID ,
1692: PREVIOUS_FACT_ID , FACT_TYPE ,
1693: FACT_REFERENCE , LAST_UPDATE_LOGIN,
1694: FORECAST_REMAINING_QUANTITY , NODE_ID)
1695: VALUES ( ozf_act_metric_facts_all_s.nextval , sysdate ,
1696: fnd_global.user_id , sysdate ,
1697: fnd_global.user_id , 1 ,
1698: p_forecast_id , 'FCST' ,
1699: 'NUMERIC' , p_activity_metric_id,

Line 6190: --l_act_metric_fact_id_level_1 := ozf_act_metric_facts_all_s.nextval;

6186: l_previous_activity_metric_id
6187: )
6188: LOOP
6189: -- generating activity_metric_fact_id for each record in Level One with the sequence
6190: --l_act_metric_fact_id_level_1 := ozf_act_metric_facts_all_s.nextval;
6191: SELECT ozf_act_metric_facts_all_s.nextval INTO l_act_metric_fact_id_level_1 FROM dual;
6192:
6193: INSERT INTO ozf_act_metric_facts_all (
6194: ACTIVITY_METRIC_FACT_ID ,

Line 6191: SELECT ozf_act_metric_facts_all_s.nextval INTO l_act_metric_fact_id_level_1 FROM dual;

6187: )
6188: LOOP
6189: -- generating activity_metric_fact_id for each record in Level One with the sequence
6190: --l_act_metric_fact_id_level_1 := ozf_act_metric_facts_all_s.nextval;
6191: SELECT ozf_act_metric_facts_all_s.nextval INTO l_act_metric_fact_id_level_1 FROM dual;
6192:
6193: INSERT INTO ozf_act_metric_facts_all (
6194: ACTIVITY_METRIC_FACT_ID ,
6195: LAST_UPDATE_DATE ,

Line 6265: --l_act_metric_fact_id_level_2 := ozf_act_metric_facts_all_s.nextval;

6261: )
6262: LOOP
6263:
6264: -- generating activity_metric_fact_id for each record in Level Two with the sequence
6265: --l_act_metric_fact_id_level_2 := ozf_act_metric_facts_all_s.nextval;
6266: SELECT ozf_act_metric_facts_all_s.nextval INTO l_act_metric_fact_id_level_2 FROM dual;
6267:
6268: INSERT INTO ozf_act_metric_facts_all (
6269: ACTIVITY_METRIC_FACT_ID ,

Line 6266: SELECT ozf_act_metric_facts_all_s.nextval INTO l_act_metric_fact_id_level_2 FROM dual;

6262: LOOP
6263:
6264: -- generating activity_metric_fact_id for each record in Level Two with the sequence
6265: --l_act_metric_fact_id_level_2 := ozf_act_metric_facts_all_s.nextval;
6266: SELECT ozf_act_metric_facts_all_s.nextval INTO l_act_metric_fact_id_level_2 FROM dual;
6267:
6268: INSERT INTO ozf_act_metric_facts_all (
6269: ACTIVITY_METRIC_FACT_ID ,
6270: LAST_UPDATE_DATE ,

Line 6342: --l_act_metric_fact_id_level_3 := ozf_act_metric_facts_all_s.nextval;

6338: )
6339: LOOP
6340:
6341: -- generating activity_metric_fact_id for each new record in Level Three with the sequence
6342: --l_act_metric_fact_id_level_3 := ozf_act_metric_facts_all_s.nextval;
6343: SELECT ozf_act_metric_facts_all_s.nextval INTO l_act_metric_fact_id_level_3 FROM dual;
6344:
6345: INSERT INTO ozf_act_metric_facts_all (
6346: ACTIVITY_METRIC_FACT_ID ,

Line 6343: SELECT ozf_act_metric_facts_all_s.nextval INTO l_act_metric_fact_id_level_3 FROM dual;

6339: LOOP
6340:
6341: -- generating activity_metric_fact_id for each new record in Level Three with the sequence
6342: --l_act_metric_fact_id_level_3 := ozf_act_metric_facts_all_s.nextval;
6343: SELECT ozf_act_metric_facts_all_s.nextval INTO l_act_metric_fact_id_level_3 FROM dual;
6344:
6345: INSERT INTO ozf_act_metric_facts_all (
6346: ACTIVITY_METRIC_FACT_ID ,
6347: LAST_UPDATE_DATE ,