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_BI_DIMENSION_UTILS_PKG dependencies on FEM_DIM_ATTR_VERSIONS_B

Line 679: ,fem_dim_attr_versions_b v

675: ,fem_cal_periods_b cp2
676: ,fem_cal_periods_attr cpa2_adj
677: ,fem_dimensions_b dim
678: ,fem_dim_attributes_b a
679: ,fem_dim_attr_versions_b v
680: where cp.cal_period_id = p_cal_period_id
681: and dim.dimension_varchar_label = 'CAL_PERIOD'
682: and a.dimension_id = dim.dimension_id
683: and a.attribute_varchar_label = 'ADJ_PERIOD_FLAG'

Line 758: ,fem_dim_attr_versions_b v_adj

754: ,fem_cal_periods_attr cpa2_start
755: ,fem_cal_periods_attr cpa2_end
756: ,fem_dimensions_b dim
757: ,fem_dim_attributes_b a_adj
758: ,fem_dim_attr_versions_b v_adj
759: ,fem_dim_attributes_b a_start
760: ,fem_dim_attr_versions_b v_start
761: ,fem_dim_attributes_b a_end
762: ,fem_dim_attr_versions_b v_end

Line 760: ,fem_dim_attr_versions_b v_start

756: ,fem_dimensions_b dim
757: ,fem_dim_attributes_b a_adj
758: ,fem_dim_attr_versions_b v_adj
759: ,fem_dim_attributes_b a_start
760: ,fem_dim_attr_versions_b v_start
761: ,fem_dim_attributes_b a_end
762: ,fem_dim_attr_versions_b v_end
763: where cp.cal_period_id = p_cal_period_id
764: and dim.dimension_varchar_label = 'CAL_PERIOD'

Line 762: ,fem_dim_attr_versions_b v_end

758: ,fem_dim_attr_versions_b v_adj
759: ,fem_dim_attributes_b a_start
760: ,fem_dim_attr_versions_b v_start
761: ,fem_dim_attributes_b a_end
762: ,fem_dim_attr_versions_b v_end
763: where cp.cal_period_id = p_cal_period_id
764: and dim.dimension_varchar_label = 'CAL_PERIOD'
765: and a_adj.dimension_id = dim.dimension_id
766: and a_adj.attribute_varchar_label = 'ADJ_PERIOD_FLAG'

Line 2048: ,fem_dim_attr_versions_b v

2044: ,a.attribute_value_column_name
2045: ,a.attribute_dimension_id
2046: ,dim.dimension_varchar_label as attr_dimension_varchar_label
2047: from fem_dim_attributes_b a
2048: ,fem_dim_attr_versions_b v
2049: ,fem_dimensions_b dim
2050: where a.dimension_id = p_dimension_id
2051: and a.personal_flag = 'N'
2052: and a.queryable_for_reporting_flag = 'Y'

Line 2127: ,fem_dim_attr_versions_b v

2123: ,v.version_id
2124: into l_sign_attribute_id
2125: ,l_sign_attr_version_id
2126: from fem_dim_attributes_b a
2127: ,fem_dim_attr_versions_b v
2128: where a.dimension_id = attr_rec.attribute_dimension_id
2129: and a.attribute_varchar_label = 'SIGN'
2130: and v.attribute_id = a.attribute_id
2131: and v.default_version_flag = 'Y';

Line 2150: ,fem_dim_attr_versions_b v

2146: ,v.version_id
2147: into l_bsc_attribute_id
2148: ,l_bsc_attr_version_id
2149: from fem_dim_attributes_b a
2150: ,fem_dim_attr_versions_b v
2151: where a.dimension_id = attr_rec.attribute_dimension_id
2152: and a.attribute_varchar_label = 'BASIC_ACCOUNT_TYPE_CODE'
2153: and v.attribute_id = a.attribute_id
2154: and v.default_version_flag = 'Y';

Line 2358: ,version_display_code fem_dim_attr_versions_b.version_display_code%type

2354: -- Declare types --
2355: -------------------
2356: type attribute_record is record (
2357: attribute_varchar_label fem_dim_attributes_b.attribute_varchar_label%type
2358: ,version_display_code fem_dim_attr_versions_b.version_display_code%type
2359: ,attribute_data_type_code fem_dim_attributes_b.attribute_data_type_code%type
2360: ,attribute_value_column_name fem_dim_attributes_b.attribute_value_column_name%type
2361: ,attribute_dimension_id fem_dim_attributes_b.attribute_dimension_id%type
2362: ,attr_dimension_varchar_label fem_dimensions_b.dimension_varchar_label%type

Line 2453: ' ,fem_dim_attr_versions_b@'||p_seed_db_link||' v'||

2449: ' ,a.attribute_value_column_name'||
2450: ' ,a.attribute_dimension_id'||
2451: ' ,dim.dimension_varchar_label as attr_dimension_varchar_label'||
2452: ' from fem_dim_attributes_b@'||p_seed_db_link||' a'||
2453: ' ,fem_dim_attr_versions_b@'||p_seed_db_link||' v'||
2454: ' ,fem_dimensions_b@'||p_seed_db_link||' dim'||
2455: ' where a.dimension_id = :b_dimension_id'||
2456: ' and a.personal_flag = ''N'''||
2457: ' and a.queryable_for_reporting_flag = ''Y'''||

Line 2515: ' ,fem_dim_attr_versions_b v'||

2511: ' select adb.'||l_attr_mem_display_code_col||
2512: ' from '||l_attr_mem_b_tab||' adb'||
2513: ' ,'||p_attribute_table_name||' attr'||
2514: ' ,fem_dim_attributes_b a'||
2515: ' ,fem_dim_attr_versions_b v'||
2516: ' where adb.'||l_attr_mem_col||' = attr.'||l_attr_tbl(i).attribute_value_column_name||
2517: l_attrd_value_set_where||
2518: ' and a.dimension_id = '||p_dimension_id||
2519: ' and a.attribute_varchar_label = '''||l_attr_tbl(i).attribute_varchar_label||''''||

Line 2532: ' ,fem_dim_attr_versions_b v'||

2528: ' select adtl.'||l_attr_mem_name_col||
2529: ' from '||l_attr_mem_tl_tab||' adtl'||
2530: ' ,'||p_attribute_table_name||' attr'||
2531: ' ,fem_dim_attributes_b a'||
2532: ' ,fem_dim_attr_versions_b v'||
2533: ' where adtl.'||l_attr_mem_col||' = attr.'||l_attr_tbl(i).attribute_value_column_name||
2534: l_attrn_value_set_where||
2535: l_attrn_language_where||
2536: ' and a.dimension_id = '||p_dimension_id||

Line 2554: ' ,fem_dim_attr_versions_b v'||

2550: l_sign_attrd_sql_stmt :=
2551: ' select ext_attr.number_assign_value'||
2552: ' from '||p_attribute_table_name||' attr'||
2553: ' ,fem_dim_attributes_b a'||
2554: ' ,fem_dim_attr_versions_b v'||
2555: ' ,fem_ext_acct_types_attr ext_attr'||
2556: ' ,fem_dim_attributes_b ext_a'||
2557: ' ,fem_dim_attr_versions_b ext_v'||
2558: ' where a.dimension_id = '||p_dimension_id||

Line 2557: ' ,fem_dim_attr_versions_b ext_v'||

2553: ' ,fem_dim_attributes_b a'||
2554: ' ,fem_dim_attr_versions_b v'||
2555: ' ,fem_ext_acct_types_attr ext_attr'||
2556: ' ,fem_dim_attributes_b ext_a'||
2557: ' ,fem_dim_attr_versions_b ext_v'||
2558: ' where a.dimension_id = '||p_dimension_id||
2559: ' and a.attribute_varchar_label = '''||l_attr_tbl(i).attribute_varchar_label||''''||
2560: ' and v.attribute_id = a.attribute_id'||
2561: ' and v.version_display_code = '''||l_attr_tbl(i).version_display_code||''''||

Line 2578: ' ,fem_dim_attr_versions_b v'||

2574: l_bsc_attrd_sql_stmt :=
2575: ' select ext_attr.dim_attribute_varchar_member'||
2576: ' from '||p_attribute_table_name||' attr'||
2577: ' ,fem_dim_attributes_b a'||
2578: ' ,fem_dim_attr_versions_b v'||
2579: ' ,fem_ext_acct_types_attr ext_attr'||
2580: ' ,fem_dim_attributes_b ext_a'||
2581: ' ,fem_dim_attr_versions_b ext_v'||
2582: ' where a.dimension_id = '||p_dimension_id||

Line 2581: ' ,fem_dim_attr_versions_b ext_v'||

2577: ' ,fem_dim_attributes_b a'||
2578: ' ,fem_dim_attr_versions_b v'||
2579: ' ,fem_ext_acct_types_attr ext_attr'||
2580: ' ,fem_dim_attributes_b ext_a'||
2581: ' ,fem_dim_attr_versions_b ext_v'||
2582: ' where a.dimension_id = '||p_dimension_id||
2583: ' and a.attribute_varchar_label = '''||l_attr_tbl(i).attribute_varchar_label||''''||
2584: ' and v.attribute_id = a.attribute_id'||
2585: ' and v.version_display_code = '''||l_attr_tbl(i).version_display_code||''''||

Line 2602: ' ,fem_dim_attr_versions_b v'||

2598: l_bsc_attrn_sql_stmt :=
2599: ' select bsc_tl.basic_account_type_name'||
2600: ' from '||p_attribute_table_name||' attr'||
2601: ' ,fem_dim_attributes_b a'||
2602: ' ,fem_dim_attr_versions_b v'||
2603: ' ,fem_ext_acct_types_attr ext_attr'||
2604: ' ,fem_dim_attributes_b ext_a'||
2605: ' ,fem_dim_attr_versions_b ext_v'||
2606: ' ,fem_basic_acct_types_tl bsc_tl'||

Line 2605: ' ,fem_dim_attr_versions_b ext_v'||

2601: ' ,fem_dim_attributes_b a'||
2602: ' ,fem_dim_attr_versions_b v'||
2603: ' ,fem_ext_acct_types_attr ext_attr'||
2604: ' ,fem_dim_attributes_b ext_a'||
2605: ' ,fem_dim_attr_versions_b ext_v'||
2606: ' ,fem_basic_acct_types_tl bsc_tl'||
2607: ' where a.dimension_id = '||p_dimension_id||
2608: ' and a.attribute_varchar_label = '''||l_attr_tbl(i).attribute_varchar_label||''''||
2609: ' and v.attribute_id = a.attribute_id'||

Line 2633: ' ,fem_dim_attr_versions_b v'||

2629: l_attrd_sql_stmt :=
2630: ' select attr.'||l_attr_tbl(i).attribute_value_column_name||
2631: ' from '||p_attribute_table_name||' attr'||
2632: ' ,fem_dim_attributes_b a'||
2633: ' ,fem_dim_attr_versions_b v'||
2634: ' where a.dimension_id = '||p_dimension_id||
2635: ' and a.attribute_varchar_label = '''||l_attr_tbl(i).attribute_varchar_label||''''||
2636: ' and v.attribute_id = a.attribute_id'||
2637: ' and v.version_display_code = '''||l_attr_tbl(i).version_display_code||''''||