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.BSC_UPDATE dependencies on BSC_KPI_PERIODICITIES

Line 1216: bsc_kpi_periodicities

1212:
1213: -- Update indicator current period
1214: --Fix perf bug#4924515: use bsc_sys_periodicities instead of bsc_sys_periodiicties_vl
1215: UPDATE
1216: bsc_kpi_periodicities
1217: SET
1218: current_period = h_current_fy + 1
1219: WHERE
1220: indicator = h_indicator AND

Line 1231: bsc_kpi_periodicities

1227: calendar_id = x_calendar_id AND
1228: yearly_flag = 1);
1229:
1230: UPDATE
1231: bsc_kpi_periodicities
1232: SET
1233: current_period = 1
1234: WHERE
1235: indicator = h_indicator AND

Line 5830: UPDATE bsc_kpi_periodicities p

5826:
5827: -- BSC-PMF Integration:Fix this query by adding NVL, to avoid assigning NULL
5828: -- to the current period when all of the analysis options of a kpi are for PMF measures.
5829:
5830: UPDATE bsc_kpi_periodicities p
5831: SET current_period = (
5832: SELECT DISTINCT
5833: NVL(MIN(t.current_period), p.current_period)
5834: FROM

Line 5865: UPDATE bsc_kpi_periodicities p

5861:
5862: -- BSC-PMF Integration:Fix this query by adding NVL, to avoid assigning NULL
5863: -- to the current period when all of the analysis options of a kpi are for PMF measures.
5864:
5865: UPDATE bsc_kpi_periodicities p
5866: SET current_period = (
5867: SELECT DISTINCT
5868: NVL(MIN(t.current_period), p.current_period)
5869: FROM