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.BIS_TARGET_PVT dependencies on BISBV_DIMENSION_LEVELS

Line 2650: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME

2646: WHERE TARGET_LEVEL_ID = TO_NUMBER(p_target_level_id);
2647: --
2648: -- retrieve the Org level view name
2649: IF(l_bisbv_target_levels.ORG_LEVEL_ID IS NOT NULL) THEN
2650: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2651: INTO x_org_view_name
2652: FROM
2653: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2654: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID

Line 2653: BISBV_DIMENSION_LEVELS bisbv_dimension_levels

2649: IF(l_bisbv_target_levels.ORG_LEVEL_ID IS NOT NULL) THEN
2650: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2651: INTO x_org_view_name
2652: FROM
2653: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2654: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
2655: = l_bisbv_target_levels.ORG_LEVEL_ID;
2656: END IF;
2657: --

Line 2654: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID

2650: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2651: INTO x_org_view_name
2652: FROM
2653: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2654: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
2655: = l_bisbv_target_levels.ORG_LEVEL_ID;
2656: END IF;
2657: --
2658: -- retrieve the Time level view name

Line 2660: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME

2656: END IF;
2657: --
2658: -- retrieve the Time level view name
2659: IF(l_bisbv_target_levels.TIME_LEVEL_ID IS NOT NULL) THEN
2660: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2661: INTO x_time_view_name
2662: FROM
2663: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2664: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID

Line 2663: BISBV_DIMENSION_LEVELS bisbv_dimension_levels

2659: IF(l_bisbv_target_levels.TIME_LEVEL_ID IS NOT NULL) THEN
2660: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2661: INTO x_time_view_name
2662: FROM
2663: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2664: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
2665: = l_bisbv_target_levels.TIME_LEVEL_ID;
2666: END IF;
2667: --

Line 2664: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID

2660: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2661: INTO x_time_view_name
2662: FROM
2663: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2664: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
2665: = l_bisbv_target_levels.TIME_LEVEL_ID;
2666: END IF;
2667: --
2668: -- retrieve the dim1 level view name

Line 2670: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME

2666: END IF;
2667: --
2668: -- retrieve the dim1 level view name
2669: IF(l_bisbv_target_levels.DIMENSION1_LEVEL_ID IS NOT NULL) THEN
2670: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2671: INTO x_dim1_view_name
2672: FROM
2673: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2674: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID

Line 2673: BISBV_DIMENSION_LEVELS bisbv_dimension_levels

2669: IF(l_bisbv_target_levels.DIMENSION1_LEVEL_ID IS NOT NULL) THEN
2670: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2671: INTO x_dim1_view_name
2672: FROM
2673: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2674: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
2675: = l_bisbv_target_levels.DIMENSION1_LEVEL_ID;
2676: END IF;
2677: --

Line 2674: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID

2670: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2671: INTO x_dim1_view_name
2672: FROM
2673: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2674: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
2675: = l_bisbv_target_levels.DIMENSION1_LEVEL_ID;
2676: END IF;
2677: --
2678: -- retrieve the dim2 level view name

Line 2680: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME

2676: END IF;
2677: --
2678: -- retrieve the dim2 level view name
2679: IF(l_bisbv_target_levels.DIMENSION2_LEVEL_ID IS NOT NULL) THEN
2680: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2681: INTO x_dim2_view_name
2682: FROM
2683: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2684: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID

Line 2683: BISBV_DIMENSION_LEVELS bisbv_dimension_levels

2679: IF(l_bisbv_target_levels.DIMENSION2_LEVEL_ID IS NOT NULL) THEN
2680: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2681: INTO x_dim2_view_name
2682: FROM
2683: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2684: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
2685: = l_bisbv_target_levels.DIMENSION2_LEVEL_ID;
2686: END IF;
2687: --

Line 2684: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID

2680: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2681: INTO x_dim2_view_name
2682: FROM
2683: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2684: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
2685: = l_bisbv_target_levels.DIMENSION2_LEVEL_ID;
2686: END IF;
2687: --
2688: -- retrieve the dim3 level view name

Line 2690: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME

2686: END IF;
2687: --
2688: -- retrieve the dim3 level view name
2689: IF(l_bisbv_target_levels.DIMENSION3_LEVEL_ID IS NOT NULL) THEN
2690: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2691: INTO x_dim3_view_name
2692: FROM
2693: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2694: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID

Line 2693: BISBV_DIMENSION_LEVELS bisbv_dimension_levels

2689: IF(l_bisbv_target_levels.DIMENSION3_LEVEL_ID IS NOT NULL) THEN
2690: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2691: INTO x_dim3_view_name
2692: FROM
2693: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2694: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
2695: = l_bisbv_target_levels.DIMENSION3_LEVEL_ID;
2696: END IF;
2697: --

Line 2694: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID

2690: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2691: INTO x_dim3_view_name
2692: FROM
2693: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2694: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
2695: = l_bisbv_target_levels.DIMENSION3_LEVEL_ID;
2696: END IF;
2697: --
2698: -- retrieve the dim4 level view name

Line 2700: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME

2696: END IF;
2697: --
2698: -- retrieve the dim4 level view name
2699: IF(l_bisbv_target_levels.DIMENSION4_LEVEL_ID IS NOT NULL) THEN
2700: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2701: INTO x_dim4_view_name
2702: FROM
2703: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2704: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID

Line 2703: BISBV_DIMENSION_LEVELS bisbv_dimension_levels

2699: IF(l_bisbv_target_levels.DIMENSION4_LEVEL_ID IS NOT NULL) THEN
2700: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2701: INTO x_dim4_view_name
2702: FROM
2703: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2704: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
2705: = l_bisbv_target_levels.DIMENSION4_LEVEL_ID;
2706: END IF;
2707: --

Line 2704: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID

2700: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2701: INTO x_dim4_view_name
2702: FROM
2703: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2704: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
2705: = l_bisbv_target_levels.DIMENSION4_LEVEL_ID;
2706: END IF;
2707: --
2708: -- retrieve the dim5 level view name

Line 2710: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME

2706: END IF;
2707: --
2708: -- retrieve the dim5 level view name
2709: IF(l_bisbv_target_levels.DIMENSION5_LEVEL_ID IS NOT NULL) THEN
2710: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2711: INTO x_dim5_view_name
2712: FROM
2713: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2714: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID

Line 2713: BISBV_DIMENSION_LEVELS bisbv_dimension_levels

2709: IF(l_bisbv_target_levels.DIMENSION5_LEVEL_ID IS NOT NULL) THEN
2710: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2711: INTO x_dim5_view_name
2712: FROM
2713: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2714: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
2715: = l_bisbv_target_levels.DIMENSION5_LEVEL_ID;
2716: END IF;
2717: -- retrieve the dim6 level view name

Line 2714: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID

2710: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2711: INTO x_dim5_view_name
2712: FROM
2713: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2714: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
2715: = l_bisbv_target_levels.DIMENSION5_LEVEL_ID;
2716: END IF;
2717: -- retrieve the dim6 level view name
2718: IF(l_bisbv_target_levels.DIMENSION6_LEVEL_ID IS NOT NULL) THEN

Line 2719: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME

2715: = l_bisbv_target_levels.DIMENSION5_LEVEL_ID;
2716: END IF;
2717: -- retrieve the dim6 level view name
2718: IF(l_bisbv_target_levels.DIMENSION6_LEVEL_ID IS NOT NULL) THEN
2719: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2720: INTO x_dim6_view_name
2721: FROM
2722: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2723: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID

Line 2722: BISBV_DIMENSION_LEVELS bisbv_dimension_levels

2718: IF(l_bisbv_target_levels.DIMENSION6_LEVEL_ID IS NOT NULL) THEN
2719: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2720: INTO x_dim6_view_name
2721: FROM
2722: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2723: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
2724: = l_bisbv_target_levels.DIMENSION6_LEVEL_ID;
2725: END IF;
2726: -- retrieve the dim7 level view name

Line 2723: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID

2719: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2720: INTO x_dim6_view_name
2721: FROM
2722: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2723: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
2724: = l_bisbv_target_levels.DIMENSION6_LEVEL_ID;
2725: END IF;
2726: -- retrieve the dim7 level view name
2727: IF(l_bisbv_target_levels.DIMENSION7_LEVEL_ID IS NOT NULL) THEN

Line 2728: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME

2724: = l_bisbv_target_levels.DIMENSION6_LEVEL_ID;
2725: END IF;
2726: -- retrieve the dim7 level view name
2727: IF(l_bisbv_target_levels.DIMENSION7_LEVEL_ID IS NOT NULL) THEN
2728: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2729: INTO x_dim7_view_name
2730: FROM
2731: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2732: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID

Line 2731: BISBV_DIMENSION_LEVELS bisbv_dimension_levels

2727: IF(l_bisbv_target_levels.DIMENSION7_LEVEL_ID IS NOT NULL) THEN
2728: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2729: INTO x_dim7_view_name
2730: FROM
2731: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2732: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
2733: = l_bisbv_target_levels.DIMENSION7_LEVEL_ID;
2734: END IF;
2735: --

Line 2732: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID

2728: SELECT bisbv_dimension_levels.LEVEL_VALUES_VIEW_NAME
2729: INTO x_dim7_view_name
2730: FROM
2731: BISBV_DIMENSION_LEVELS bisbv_dimension_levels
2732: WHERE bisbv_dimension_levels.DIMENSION_LEVEL_ID
2733: = l_bisbv_target_levels.DIMENSION7_LEVEL_ID;
2734: END IF;
2735: --
2736: --