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_ATTRIBUTES_B

Line 678: ,fem_dim_attributes_b a

674: ,fem_cal_periods_attr cpa_adj
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

Line 757: ,fem_dim_attributes_b a_adj

753: ,fem_cal_periods_attr cpa2_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

Line 759: ,fem_dim_attributes_b a_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
763: where cp.cal_period_id = p_cal_period_id

Line 761: ,fem_dim_attributes_b a_end

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'
765: and a_adj.dimension_id = dim.dimension_id

Line 2047: from fem_dim_attributes_b a

2043: ,a.attribute_data_type_code
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'

Line 2126: from fem_dim_attributes_b a

2122: select a.attribute_id
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

Line 2149: from fem_dim_attributes_b a

2145: select a.attribute_id
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

Line 2357: attribute_varchar_label fem_dim_attributes_b.attribute_varchar_label%type

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

Line 2359: ,attribute_data_type_code fem_dim_attributes_b.attribute_data_type_code%type

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
2363: );

Line 2360: ,attribute_value_column_name fem_dim_attributes_b.attribute_value_column_name%type

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
2363: );
2364:

Line 2361: ,attribute_dimension_id fem_dim_attributes_b.attribute_dimension_id%type

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
2363: );
2364:
2365: type attribute_table is table of attribute_record

Line 2452: ' from fem_dim_attributes_b@'||p_seed_db_link||' a'||

2448: ' ,a.attribute_data_type_code'||
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'''||

Line 2514: ' ,fem_dim_attributes_b a'||

2510: l_attrd_sql_stmt :=
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||

Line 2531: ' ,fem_dim_attributes_b a'||

2527: l_attrn_sql_stmt :=
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||

Line 2553: ' ,fem_dim_attributes_b a'||

2549:
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'||

Line 2556: ' ,fem_dim_attributes_b ext_a'||

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||
2559: ' and a.attribute_varchar_label = '''||l_attr_tbl(i).attribute_varchar_label||''''||
2560: ' and v.attribute_id = a.attribute_id'||

Line 2577: ' ,fem_dim_attributes_b a'||

2573:
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'||

Line 2580: ' ,fem_dim_attributes_b ext_a'||

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||
2583: ' and a.attribute_varchar_label = '''||l_attr_tbl(i).attribute_varchar_label||''''||
2584: ' and v.attribute_id = a.attribute_id'||

Line 2601: ' ,fem_dim_attributes_b a'||

2597:
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'||

Line 2604: ' ,fem_dim_attributes_b ext_a'||

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'||
2607: ' where a.dimension_id = '||p_dimension_id||
2608: ' and a.attribute_varchar_label = '''||l_attr_tbl(i).attribute_varchar_label||''''||

Line 2632: ' ,fem_dim_attributes_b a'||

2628:
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'||