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.FEM_DIM_MEMBER_LOADER_PKG dependencies on FEM_DIMENSIONS_B

Line 9678: ',fem_dimensions_b B1'||

9674: 'SELECT T2.base_rowid'||
9675: ' ,''INVALID_LVL_SPEC_ATTR_LABEL'' '||
9676: ' FROM fem_dim_attributes_b A1'||
9677: ',fem_dim_attr_versions_b V1'||
9678: ',fem_dimensions_b B1'||
9679: ',(SELECT B.rowid base_rowid'||
9680: ', B.attribute_varchar_label,'||v_member_code||' MEMBER_CODE'||
9681: ', B.cal_period_number CAL_PERIOD_NUMBER'||
9682: ', C.calendar_id CALENDAR_ID'||

Line 9729: ',fem_dimensions_b B1'||

9725: 'SELECT T2.base_rowid'||
9726: ' ,''INVALID_LVL_SPEC_ATTR_LABEL'' '||
9727: ' FROM fem_dim_attributes_b A1'||
9728: ',fem_dim_attr_versions_b V1'||
9729: ',fem_dimensions_b B1'||
9730: ',(SELECT B.rowid base_rowid'||
9731: ', B.attribute_varchar_label,'||v_member_code||' MEMBER_CODE'||
9732: ', B.value_set_display_code'||
9733: ', B.version_display_code'||

Line 9773: ',fem_dimensions_b B1'||

9769: 'SELECT T2.base_rowid'||
9770: ' ,''INVALID_LVL_SPEC_ATTR_LABEL'' '||
9771: ' FROM fem_dim_attributes_b A1'||
9772: ',fem_dim_attr_versions_b V1'||
9773: ',fem_dimensions_b B1'||
9774: ',(SELECT B.rowid base_rowid'||
9775: ', B.attribute_varchar_label,'||v_member_code||' MEMBER_CODE'||
9776: ', B.version_display_code'||
9777: ', B.attribute_assign_value'||

Line 10029: ',fem_dimensions_b B1'||

10025: ', T2.CALPATTR_END_DATE'||
10026: ', T2.CALPATTR_PERIOD_NUM'||
10027: ' FROM fem_dim_attributes_b A1'||
10028: ',fem_dim_attr_versions_b V1'||
10029: ',fem_dimensions_b B1'||
10030: ',(SELECT B.rowid base_rowid'||
10031: ', B.attribute_varchar_label,'||v_member_code||' MEMBER_CODE'||
10032: ', D.dimension_group_id'||
10033: ', B.version_display_code'||

Line 10101: ',fem_dimensions_b B1'||

10097: ' ,T2.CALPATTR_END_DATE'||
10098: ' ,T2.CALPATTR_PERIOD_NUM'||
10099: ' FROM fem_dim_attributes_b A1'||
10100: ',fem_dim_attr_versions_b V1'||
10101: ',fem_dimensions_b B1'||
10102: ',(SELECT B.rowid base_rowid'||
10103: ', B.attribute_varchar_label,'||v_member_code||' MEMBER_CODE'||
10104: ', B.cal_period_number CAL_PERIOD_NUMBER'||
10105: ', C.calendar_id CALENDAR_ID'||

Line 10184: ',fem_dimensions_b B1'||

10180: ' ,T2.CALPATTR_END_DATE'||
10181: ' ,T2.CALPATTR_PERIOD_NUM'||
10182: ' FROM fem_dim_attributes_b A1'||
10183: ',fem_dim_attr_versions_b V1'||
10184: ',fem_dimensions_b B1'||
10185: ',(SELECT B.rowid base_rowid'||
10186: ', B.attribute_varchar_label,B.'||v_member_code||' MEMBER_CODE'||
10187: ', B.value_set_display_code'||
10188: ', B.version_display_code'||

Line 10245: ',fem_dimensions_b B1'||

10241: ' ,T2.CALPATTR_END_DATE'||
10242: ' ,T2.CALPATTR_PERIOD_NUM'||
10243: ' FROM fem_dim_attributes_b A1'||
10244: ',fem_dim_attr_versions_b V1'||
10245: ',fem_dimensions_b B1'||
10246: ',(SELECT B.rowid base_rowid'||
10247: ', B.attribute_varchar_label,B.'||v_member_code||' MEMBER_CODE'||
10248: ', B.version_display_code'||
10249: ', B.attribute_assign_value'||

Line 10312: ',fem_dimensions_b B1'||

10308: ' ,T2.CALPATTR_END_DATE'||
10309: ' ,T2.CALPATTR_PERIOD_NUM'||
10310: ' FROM fem_dim_attributes_b A1'||
10311: ',fem_dim_attr_versions_b V1'||
10312: ',fem_dimensions_b B1'||
10313: ',(SELECT B.rowid base_rowid'||
10314: ', B.attribute_varchar_label,'||v_member_code||' MEMBER_CODE'||
10315: ', B.value_set_display_code'||
10316: ', B.version_display_code'||

Line 10386: ',fem_dimensions_b B1'||

10382: ' ,T2.CALPATTR_END_DATE'||
10383: ' ,T2.CALPATTR_PERIOD_NUM'||
10384: ' FROM fem_dim_attributes_b A1'||
10385: ',fem_dim_attr_versions_b V1'||
10386: ',fem_dimensions_b B1'||
10387: ',(SELECT B.rowid base_rowid'||
10388: ', B.attribute_varchar_label,'||v_member_code||' MEMBER_CODE'||
10389: ', B.value_set_display_code'||
10390: ', B.version_display_code'||

Line 10454: ',fem_dimensions_b B1'||

10450: ' ,T2.CALPATTR_END_DATE'||
10451: ' ,T2.CALPATTR_PERIOD_NUM'||
10452: ' FROM fem_dim_attributes_b A1'||
10453: ',fem_dim_attr_versions_b V1'||
10454: ',fem_dimensions_b B1'||
10455: ',(SELECT B.rowid base_rowid'||
10456: ', B.attribute_varchar_label,'||v_member_code||' MEMBER_CODE'||
10457: ', B.version_display_code'||
10458: ', B.attribute_assign_value'||

Line 10525: ',fem_dimensions_b B1'||

10521: ' ,T2.CALPATTR_END_DATE'||
10522: ' ,T2.CALPATTR_PERIOD_NUM'||
10523: ' FROM fem_dim_attributes_b A1'||
10524: ',fem_dim_attr_versions_b V1'||
10525: ',fem_dimensions_b B1'||
10526: ',(SELECT B.rowid base_rowid'||
10527: ', B.attribute_varchar_label,'||v_member_code||' MEMBER_CODE'||
10528: ', B.version_display_code'||
10529: ', B.attribute_assign_value'||

Line 10593: ',fem_dimensions_b B1'||

10589: ' ,T2.CALPATTR_END_DATE'||
10590: ' ,T2.CALPATTR_PERIOD_NUM'||
10591: ' FROM fem_dim_attributes_b A1'||
10592: ',fem_dim_attr_versions_b V1'||
10593: ',fem_dimensions_b B1'||
10594: ',(SELECT B.rowid base_rowid'||
10595: ', B.attribute_varchar_label,'||v_member_code||' MEMBER_CODE'||
10596: ', B.version_display_code'||
10597: ', B.attribute_assign_value'||

Line 10654: ',fem_dimensions_b B1'||

10650: ' ,T2.CALPATTR_END_DATE'||
10651: ' ,T2.CALPATTR_PERIOD_NUM'||
10652: ' FROM fem_dim_attributes_b A1'||
10653: ',fem_dim_attr_versions_b V1'||
10654: ',fem_dimensions_b B1'||
10655: ',(SELECT B.rowid base_rowid'||
10656: ', B.attribute_varchar_label,'||v_member_code||' MEMBER_CODE'||
10657: ', B.version_display_code'||
10658: ', B.attribute_assign_value'||

Line 11346: FROM fem_dimensions_b B1, fem_dim_attributes_b A1, fem_dimensions_b B2

11342:
11343:
11344: SELECT B2.dimension_varchar_label
11345: INTO v_attr_dimension_varchar_label
11346: FROM fem_dimensions_b B1, fem_dim_attributes_b A1, fem_dimensions_b B2
11347: WHERE B1.dimension_id = A1.dimension_id
11348: AND A1.attribute_varchar_label = p_attribute_varchar_label
11349: AND B1.dimension_varchar_label = p_dimension_varchar_label
11350: AND B2.dimension_id = A1.attribute_dimension_id;

Line 11763: FROM fem_dim_attr_versions_b B, fem_dim_attributes_b A, fem_dimensions_b D

11759: p_version_display_code);
11760:
11761: SELECT B.version_id
11762: INTO x_version_id
11763: FROM fem_dim_attr_versions_b B, fem_dim_attributes_b A, fem_dimensions_b D
11764: WHERE B.version_display_code = p_version_display_code
11765: AND B.attribute_id = A.attribute_id
11766: AND A.attribute_varchar_label = p_attribute_varchar_label
11767: AND D.dimension_varchar_label = p_dimension_varchar_label

Line 12394: ' ,fem_dimensions_b D '||

12390: x_update_status_stmt := 'UPDATE '||p_source_attr_table||' B'||
12391: ' SET status = ''INVALID_ATTRIBUTE_LABEL'' '||
12392: ' WHERE attribute_varchar_label NOT IN (SELECT '||
12393: ' attribute_varchar_label FROM fem_dim_attributes_b A'||
12394: ' ,fem_dimensions_b D '||
12395: ' WHERE D.dimension_varchar_label = '''||p_dimension_varchar_label||''''||
12396: ' AND D.dimension_id = A.dimension_id)'||
12397: ' AND B.status '||p_exec_mode_clause||
12398: v_dim_label_where_cond||

Line 12457: ' ,fem_dimensions_b D '||

12453: x_update_status_stmt := 'UPDATE '||p_source_attr_table||' B'||
12454: ' SET status = ''ATTR_LABEL_NOT_USER_ASSIGN'' '||
12455: ' WHERE attribute_varchar_label IN (SELECT '||
12456: ' attribute_varchar_label FROM fem_dim_attributes_b A'||
12457: ' ,fem_dimensions_b D '||
12458: ' WHERE D.dimension_varchar_label = '''||p_dimension_varchar_label||''''||
12459: ' AND nvl(A.user_assign_allowed_flag,''Y'') = ''N'''||
12460: ' AND D.dimension_id = A.dimension_id)'||
12461: ' AND B.status '||p_exec_mode_clause||

Line 12788: ', fem_dimensions_b D'||

12784: ',B.time_group_type_code'||
12785: ', ''LOAD'' '||
12786: ' FROM '||p_source_b_table||' B'||
12787: ', '||p_target_b_table||' TB'||
12788: ', fem_dimensions_b D'||
12789: ' WHERE B.status'||p_exec_mode_clause||
12790: ' AND B.dimension_varchar_label = D.dimension_varchar_label'||
12791: ' AND D.dimension_id = TB.dimension_id'||
12792: ' AND TB.dimension_group_display_code = B.dimension_group_display_code'||

Line 17167: FROM fem_xdim_dimensions X, fem_dimensions_b B

17163: INTO v_hier_editor_managed_flag
17164: ,v_xdim_read_only_flag
17165: ,v_value_set_required_flag
17166: ,v_simple_dimension_flag
17167: FROM fem_xdim_dimensions X, fem_dimensions_b B
17168: WHERE B.dimension_varchar_label = v_dimension_varchar_label
17169: AND B.dimension_id = X.dimension_id;
17170: EXCEPTION
17171: WHEN no_data_found THEN