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.ZPB_BUSAREA_VAL dependencies on ZPB_BUSAREA_DIMENSIONS

Line 303: l_dimension_id ZPB_BUSAREA_DIMENSIONS.DIMENSION_ID%type;

299: is
300: l_spec_dim_list VARCHAR2(512);
301: l_dataset_id ZPB_BUSAREA_DATASETS.DATASET_ID%type;
302: l_currency ZPB_BUSAREA_VERSIONS.CURRENCY_ENABLED%type;
303: l_dimension_id ZPB_BUSAREA_DIMENSIONS.DIMENSION_ID%type;
304: l_cursor epb_cur_type;
305: l_datatable_dim_list VARCHAR2(1000);
306: l_dataset_dim_list VARCHAR2(1000);
307: l_missing_dim_list VARCHAR2(1000);

Line 440: from ZPB_BUSAREA_DIMENSIONS

436:
437: l_command := l_command ||
438: ' where dimension_id not in (
439: select dimension_id
440: from ZPB_BUSAREA_DIMENSIONS
441: where version_id = ' || p_version_id;
442: -- only get those dimensions that haven't been added previously
443: if (length(l_missing_dim_list) > 0) then
444: if (substr(l_missing_dim_list, length(l_missing_dim_list)) = ',') then

Line 533: from ZPB_BUSAREA_DIMENSIONS A

529: cursor c_def_hierarchies is
530: select A.DIMENSION_ID,
531: A.DEFAULT_HIERARCHY_ID,
532: A.LOGICAL_DIM_ID
533: from ZPB_BUSAREA_DIMENSIONS A
534: where A.VERSION_ID = p_version_id
535: and A.DEFAULT_HIERARCHY_ID not in
536: (select HIERARCHY_OBJ_ID
537: from FEM_HIERARCHIES

Line 597: from ZPB_BUSAREA_DIMENSIONS A, FEM_XDIM_DIMENSIONS B

593:
594: cursor c_dimensions is
595: select A.DIMENSION_ID, B.HIER_EDITOR_MANAGED_FLAG,
596: A.LOGICAL_DIM_ID
597: from ZPB_BUSAREA_DIMENSIONS A, FEM_XDIM_DIMENSIONS B
598: where A.VERSION_ID = p_version_id
599: and A.DIMENSION_ID = B.DIMENSION_ID;
600:
601: begin

Line 623: update ZPB_BUSAREA_DIMENSIONS

619: --
620: for each in c_def_hierarchies loop
621: REGISTER_ERROR('S', 'W', 'ZPB_BUSAREA_VAL_REMOVED',
622: 'OBJ_TYPE', 'ZPB_DEFAULT_HIERARCHY', 'Y');
623: update ZPB_BUSAREA_DIMENSIONS
624: set DEFAULT_HIERARCHY_ID = null,
625: LAST_UPDATE_DATE = sysdate,
626: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
627: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 697: ZPB_BUSAREA_DIMENSIONS B

693: A.MEMBER_COL,
694: A.VALUE_SET_REQUIRED_FLAG
695: into l_dim_table, l_hier_table, l_col, l_vset_required
696: from FEM_XDIM_DIMENSIONS A,
697: ZPB_BUSAREA_DIMENSIONS B
698: where B.DIMENSION_ID = each.DIMENSION_ID
699: and B.VERSION_ID = p_version_id
700: and B.LOGICAL_DIM_ID = each.LOGICAL_DIM_ID
701: AND A.DIMENSION_ID = B.DIMENSION_ID;

Line 844: from ZPB_BUSAREA_DIMENSIONS A,

840: A.AW_DIM_PREFIX,
841: DECODE(nvl(FDR.FUNC_DIM_SET_NAME, '-99'), '-99',
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

Line 980: from ZPB_BUSAREA_DIMENSIONS A, FEM_XDIM_DIMENSIONS B

976: -- Validate # of ledgers, dimensions, etc
977: -------------------------------------------------------------------------
978: select count(*)
979: into l_count
980: from ZPB_BUSAREA_DIMENSIONS A, FEM_XDIM_DIMENSIONS B
981: where A.VERSION_ID = p_version_id
982: and A.DIMENSION_ID = B.DIMENSION_ID
983: and B.DIMENSION_TYPE_CODE = 'TIME';
984: if (l_count = 0) then

Line 991: from ZPB_BUSAREA_DIMENSIONS

987: end if;
988:
989: select count(*)
990: into l_count
991: from ZPB_BUSAREA_DIMENSIONS
992: where VERSION_ID = p_version_id
993: and EPB_LINE_DIMENSION = 'Y';
994: if (l_count = 0) then
995: REGISTER_ERROR('S', 'E', 'ZPB_BUSAREA_VAL_MISSING',

Line 1002: from ZPB_BUSAREA_DIMENSIONS A,

998:
999: if (l_currency = 'Y') then
1000: select count(*)
1001: into l_count
1002: from ZPB_BUSAREA_DIMENSIONS A,
1003: FEM_XDIM_DIMENSIONS B
1004: where A.VERSION_ID = p_version_id
1005: and A.DIMENSION_ID = B.DIMENSION_ID
1006: and B.MEMBER_B_TABLE_NAME = 'FEM_CURRENCIES_VL';

Line 1102: ZPB_BUSAREA_DIMENSIONS B

1098: begin
1099: select count(*)
1100: into l_count
1101: from FEM_DIM_ATTRIBUTES_B A,
1102: ZPB_BUSAREA_DIMENSIONS B
1103: where A.ATTRIBUTE_VARCHAR_LABEL = 'ZPB_ORG_CURRENCY'
1104: and A.DIMENSION_ID = B.DIMENSION_ID
1105: and B.VERSION_ID = p_version_id;
1106: if (l_count > 1) then

Line 1110: ZPB_BUSAREA_DIMENSIONS B

1106: if (l_count > 1) then
1107: select count(distinct B.DIMENSION_ID)
1108: into l_count
1109: from FEM_DIM_ATTRIBUTES_B A,
1110: ZPB_BUSAREA_DIMENSIONS B
1111: where A.ATTRIBUTE_VARCHAR_LABEL = 'ZPB_ORG_CURRENCY'
1112: and A.DIMENSION_ID = B.DIMENSION_ID
1113: and B.VERSION_ID = p_version_id;
1114:

Line 1122: ZPB_BUSAREA_DIMENSIONS B,

1118: begin
1119: select A.ATTRIBUTE_ID, A.DIMENSION_ID, B.LOGICAL_DIM_ID
1120: into l_curr_attr_id, l_org_dim_id, l_org_logical_dim_id
1121: from FEM_DIM_ATTRIBUTES_B A,
1122: ZPB_BUSAREA_DIMENSIONS B,
1123: ZPB_BUSAREA_ATTRIBUTES C
1124: where ATTRIBUTE_VARCHAR_LABEL = 'ZPB_ORG_CURRENCY'
1125: and A.DIMENSION_ID = B.DIMENSION_ID
1126: and B.LOGICAL_DIM_ID = C.LOGICAL_DIM_ID

Line 1139: ZPB_BUSAREA_DIMENSIONS B

1135: begin
1136: select A.ATTRIBUTE_ID, A.DIMENSION_ID, B.LOGICAL_DIM_ID
1137: into l_curr_attr_id, l_org_dim_id, l_org_logical_dim_id
1138: from FEM_DIM_ATTRIBUTES_B A,
1139: ZPB_BUSAREA_DIMENSIONS B
1140: where ATTRIBUTE_VARCHAR_LABEL = 'ZPB_ORG_CURRENCY'
1141: and A.DIMENSION_ID = B.DIMENSION_ID
1142: and B.VERSION_ID = p_version_id;
1143: exception

Line 1157: from ZPB_BUSAREA_DIMENSIONS A,

1153:
1154: if (l_intercompany = 'Y') then
1155: select count(*)
1156: into l_count
1157: from ZPB_BUSAREA_DIMENSIONS A,
1158: FEM_TAB_COLUMNS_B B
1159: where A.VERSION_ID = p_version_id
1160: and A.DIMENSION_ID = B.DIMENSION_ID
1161: and B.COLUMN_NAME = 'INTERCOMPANY_ID'

Line 1187: from ZPB_BUSAREA_DIMENSIONS A,

1183: -- Check to ensure line type attribute exists on the line dimension
1184: --
1185: select count(*)
1186: into l_count
1187: from ZPB_BUSAREA_DIMENSIONS A,
1188: FEM_DIM_ATTRIBUTES_B B
1189: where A.DIMENSION_ID = B.DIMENSION_ID
1190: and B.ATTRIBUTE_VARCHAR_LABEL = 'EXTENDED_ACCOUNT_TYPE'
1191: and A.EPB_LINE_DIMENSION = 'Y'

Line 1235: ZPB_BUSAREA_DIMENSIONS B

1231: A.DIMENSION_TYPE_CODE
1232: into l_dim_table, l_hier_table, l_attr_table,
1233: l_col, l_vset_required, l_dim_type
1234: from FEM_XDIM_DIMENSIONS A,
1235: ZPB_BUSAREA_DIMENSIONS B
1236: where B.DIMENSION_ID = each.DIMENSION_ID
1237: AND B.LOGICAL_DIM_ID = each.LOGICAL_DIM_ID
1238: AND B.VERSION_ID = p_version_id
1239: AND A.DIMENSION_ID = B.DIMENSION_ID;

Line 1691: ZPB_BUSAREA_DIMENSIONS B,

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
1695: and B.VERSION_ID = p_version_id

Line 1791: ZPB_BUSAREA_DIMENSIONS B,

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
1795: and B.VERSION_ID = p_version_id

Line 2008: from ZPB_BUSAREA_DIMENSIONS_VL

2004: if (instr (each.object_name, 'MODEL_QUERY') > 0) then
2005: if (l_line_dim is null) then
2006: select NAME
2007: into l_line_dim
2008: from ZPB_BUSAREA_DIMENSIONS_VL
2009: where VERSION_ID = p_version_id
2010: and DIMENSION_ID = (select MIN(DIMENSION_ID)
2011: from ZPB_BUSAREA_DIMENSIONS
2012: where VERSION_ID = p_version_id

Line 2011: from ZPB_BUSAREA_DIMENSIONS

2007: into l_line_dim
2008: from ZPB_BUSAREA_DIMENSIONS_VL
2009: where VERSION_ID = p_version_id
2010: and DIMENSION_ID = (select MIN(DIMENSION_ID)
2011: from ZPB_BUSAREA_DIMENSIONS
2012: where VERSION_ID = p_version_id
2013: and EPB_LINE_DIMENSION = 'Y');
2014: end if;
2015:

Line 2543: from ZPB_BUSAREA_DIMENSIONS_VL

2539: if (instr (each.object_name, 'MODEL_QUERY') > 0) then
2540: if (l_line_dim is null) then
2541: select NAME
2542: into l_line_dim
2543: from ZPB_BUSAREA_DIMENSIONS_VL
2544: where VERSION_ID = p_version_id
2545: and DIMENSION_ID = (select MIN(DIMENSION_ID)
2546: from ZPB_BUSAREA_DIMENSIONS
2547: where VERSION_ID = p_version_id

Line 2546: from ZPB_BUSAREA_DIMENSIONS

2542: into l_line_dim
2543: from ZPB_BUSAREA_DIMENSIONS_VL
2544: where VERSION_ID = p_version_id
2545: and DIMENSION_ID = (select MIN(DIMENSION_ID)
2546: from ZPB_BUSAREA_DIMENSIONS
2547: where VERSION_ID = p_version_id
2548: and EPB_LINE_DIMENSION = 'Y');
2549: end if;
2550: for each_query in query_objects(each.object_name,each.folder_name)

Line 2932: from ZPB_BUSAREA_DIMENSIONS A,

2928: select A.DIMENSION_ID,
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

Line 2940: from ZPB_BUSAREA_DIMENSIONS B

2936: and A.DIMENSION_ID = C.DIMENSION_ID
2937: AND FDR.FUNC_DIM_SET_ID (+) = A.FUNC_DIM_SET_ID
2938: and A.DIMENSION_ID not in
2939: (select B.DIMENSION_ID
2940: from ZPB_BUSAREA_DIMENSIONS B
2941: where B.VERSION_ID = p_version_id);
2942:
2943: -- For Added dimensions
2944: cursor l_add_dims is

Line 2946: from ZPB_BUSAREA_DIMENSIONS A,

2942:
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

Line 2952: from ZPB_BUSAREA_DIMENSIONS B

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
2952: from ZPB_BUSAREA_DIMENSIONS B
2953: where B.VERSION_ID = l_refr_vers);
2954:
2955: cursor l_line_dims is
2956: select A.DIMENSION_ID,

Line 2961: from ZPB_BUSAREA_DIMENSIONS A,

2957: DECODE(nvl(FDR.FUNC_DIM_SET_NAME, '-99'), '-99',
2958: C.DIMENSION_NAME,FDR.FUNC_DIM_SET_NAME) AS DIMENSION_NAME,
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

Line 2962: ZPB_BUSAREA_DIMENSIONS B,

2958: C.DIMENSION_NAME,FDR.FUNC_DIM_SET_NAME) AS DIMENSION_NAME,
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

Line 2985: ZPB_BUSAREA_DIMENSIONS E

2981: from table(ZPB_FEM_UTILS_PKG.GET_BUSAREA_HIERARCHIES(l_ba_id,
2982: 'R')) A,
2983: FEM_HIERARCHIES D,
2984: FEM_OBJECT_CATALOG_VL C,
2985: ZPB_BUSAREA_DIMENSIONS E
2986: where A.HIERARCHY_ID = C.OBJECT_ID
2987: and A.HIERARCHY_ID = D.HIERARCHY_OBJ_ID
2988: and A.LOGICAL_DIM_ID = E.LOGICAL_DIM_ID
2989: and D.DIMENSION_ID = E.DIMENSION_ID

Line 3007: ZPB_BUSAREA_DIMENSIONS C

3003: C.LOGICAL_DIM_ID,
3004: nvl(C.FUNC_DIM_SET_ID, -99) AS FUNC_DIM_SET_ID
3005: from FEM_DIMENSION_GRPS_VL A,
3006: ZPB_BUSAREA_LEVELS B,
3007: ZPB_BUSAREA_DIMENSIONS C
3008: where A.DIMENSION_GROUP_ID = B.LEVEL_ID
3009: and B.VERSION_ID = l_refr_vers
3010: and C.VERSION_ID = l_refr_vers
3011: and C.LOGICAL_DIM_ID = B.LOGICAL_DIM_ID

Line 3035: ZPB_BUSAREA_DIMENSIONS D

3031: D.LOGICAL_DIM_ID,
3032: nvl(D.FUNC_DIM_SET_ID, -99) AS FUNC_DIM_SET_ID
3033: from ZPB_BUSAREA_ATTRIBUTES A,
3034: FEM_DIM_ATTRIBUTES_VL C,
3035: ZPB_BUSAREA_DIMENSIONS D
3036: where A.VERSION_ID = l_refr_vers
3037: and A.ATTRIBUTE_ID = C.ATTRIBUTE_ID
3038: and C.DIMENSION_ID = D.DIMENSION_ID
3039: and A.LOGICAL_DIM_ID = D.LOGICAL_DIM_ID