APPS.ZPB_BUSAREA_VAL dependencies on FEM_DIMENSIONS_VL

Line 309: l_dimension_name FEM_DIMENSIONS_VL.DIMENSION_NAME%type;

305: l_datatable_dim_list VARCHAR2(1000);
306: l_dataset_dim_list VARCHAR2(1000);
307: l_missing_dim_list VARCHAR2(1000);
308: l_dim_list VARCHAR2(1000);
309: l_dimension_name FEM_DIMENSIONS_VL.DIMENSION_NAME%type;
310: l_command VARCHAR2(3000);
311: i NUMBER;
312: j NUMBER;
313:

Line 468: from FEM_DIMENSIONS_VL

464: if (substr(l_missing_dim_list, length(l_missing_dim_list)) = ',') then
465: l_missing_dim_list := substr(l_missing_dim_list, 1, length(l_missing_dim_list)-1);
466: end if;
467: l_command := 'select DIMENSION_NAME
468: from FEM_DIMENSIONS_VL
469: where DIMENSION_ID in ('||l_missing_dim_list||')';
470: l_missing_dim_list := '';
471: open l_cursor for l_command;
472: loop

Line 802: l_dim_name FEM_DIMENSIONS_VL.DIMENSION_NAME%type;

798:
799: l_owner_dim ZPB_DIMENSIONS.IS_OWNER_DIM%type;
800: l_def_hier ZPB_DIMENSIONS.DEFAULT_HIER%type;
801:
802: l_dim_name FEM_DIMENSIONS_VL.DIMENSION_NAME%type;
803: l_attr_name FEM_DIM_ATTRIBUTES_VL.ATTRIBUTE_NAME%type;
804:
805: l_hier_id NUMBER;
806: l_hier_vers_id NUMBER;

Line 846: FEM_DIMENSIONS_VL B,

842: B.DIMENSION_NAME,FDR.FUNC_DIM_SET_NAME) AS DIMENSION_NAME,
843: X.MEMBER_COL
844: from ZPB_BUSAREA_DIMENSIONS A,
845: FEM_FUNC_DIM_SETS_VL FDR,
846: FEM_DIMENSIONS_VL B,
847: FEM_XDIM_DIMENSIONS X
848: where A.VERSION_ID = p_version_id
849: and FDR.FUNC_DIM_SET_ID (+) = A.FUNC_DIM_SET_ID
850: and A.DIMENSION_ID = B.DIMENSION_ID

Line 1690: from FEM_DIMENSIONS_VL A,

1686:
1687: select DECODE(nvl(FDR.FUNC_DIM_SET_NAME, '-99'), '-99',
1688: A.DIMENSION_NAME,FDR.FUNC_DIM_SET_NAME) AS DIMENSION_NAME
1689: into l_dim_name
1690: from FEM_DIMENSIONS_VL A,
1691: ZPB_BUSAREA_DIMENSIONS B,
1692: FEM_FUNC_DIM_SETS_VL FDR
1693: where B.DIMENSION_ID = l_org_dim_id
1694: and B.LOGICAL_DIM_ID = l_org_logical_dim_id

Line 1790: from FEM_DIMENSIONS_VL A,

1786:
1787: select DECODE(nvl(FDR.FUNC_DIM_SET_NAME, '-99'), '-99',
1788: A.DIMENSION_NAME,FDR.FUNC_DIM_SET_NAME) AS DIMENSION_NAME
1789: into l_dim_name
1790: from FEM_DIMENSIONS_VL A,
1791: ZPB_BUSAREA_DIMENSIONS B,
1792: FEM_FUNC_DIM_SETS_VL FDR
1793: where B.DIMENSION_ID = l_org_dim_id
1794: and B.LOGICAL_DIM_ID = l_org_logical_dim_id

Line 2933: FEM_DIMENSIONS_VL C,

2929: DECODE(nvl(FDR.FUNC_DIM_SET_NAME, '-99'), '-99',
2930: C.DIMENSION_NAME,FDR.FUNC_DIM_SET_NAME) AS DIMENSION_NAME,
2931: A.LOGICAL_DIM_ID
2932: from ZPB_BUSAREA_DIMENSIONS A,
2933: FEM_DIMENSIONS_VL C,
2934: FEM_FUNC_DIM_SETS_VL FDR
2935: where A.VERSION_ID = l_refr_vers
2936: and A.DIMENSION_ID = C.DIMENSION_ID
2937: AND FDR.FUNC_DIM_SET_ID (+) = A.FUNC_DIM_SET_ID

Line 2947: FEM_DIMENSIONS_VL C

2943: -- For Added dimensions
2944: cursor l_add_dims is
2945: select A.DIMENSION_ID
2946: from ZPB_BUSAREA_DIMENSIONS A,
2947: FEM_DIMENSIONS_VL C
2948: where A.VERSION_ID = p_version_id
2949: and A.DIMENSION_ID = C.DIMENSION_ID
2950: and A.DIMENSION_ID not in
2951: (select B.DIMENSION_ID

Line 2963: FEM_DIMENSIONS_VL C,

2959: A.EPB_LINE_DIMENSION,
2960: A.LOGICAL_DIM_ID
2961: from ZPB_BUSAREA_DIMENSIONS A,
2962: ZPB_BUSAREA_DIMENSIONS B,
2963: FEM_DIMENSIONS_VL C,
2964: FEM_FUNC_DIM_SETS_VL FDR
2965: where A.DIMENSION_ID = B.DIMENSION_ID
2966: and A.DIMENSION_ID = C.DIMENSION_ID
2967: and A.VERSION_ID = p_version_id

Line 3162: from FEM_DIMENSIONS_VL

3158:
3159: if (each_hier.FUNC_DIM_SET_ID = -99) then
3160: select DIMENSION_NAME
3161: into l_val
3162: from FEM_DIMENSIONS_VL
3163: where DIMENSION_ID = each_hier.FEM_DIMENSION_ID;
3164: else
3165: select FUNC_DIM_SET_NAME
3166: into l_val

Line 3195: from FEM_DIMENSIONS_VL

3191:
3192: if (each_level.FUNC_DIM_SET_ID = -99) then
3193: select DIMENSION_NAME
3194: into l_val
3195: from FEM_DIMENSIONS_VL
3196: where DIMENSION_ID = each_level.FEM_DIMENSION_ID;
3197: else
3198: select FUNC_DIM_SET_NAME
3199: into l_val

Line 3222: from FEM_DIMENSIONS_VL

3218:
3219: if (each_attr.FUNC_DIM_SET_ID = -99) then
3220: select DIMENSION_NAME
3221: into l_val
3222: from FEM_DIMENSIONS_VL
3223: where DIMENSION_ID = each_attr.FEM_DIMENSION_ID;
3224: else
3225: select FUNC_DIM_SET_NAME
3226: into l_val