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_VALUE_SETS_B

Line 3985: FROM fem_value_sets_b

3981: IF (ta_attr_assign_vs_dc(j) IS NOT NULL) THEN
3982: BEGIN
3983: SELECT value_set_id
3984: INTO ta_attr_assign_vs_id(j)
3985: FROM fem_value_sets_b
3986: WHERE value_set_display_code = ta_attr_assign_vs_dc(j)
3987: AND dimension_id = ta_attribute_dimension_id(j);
3988: EXCEPTION
3989: WHEN no_data_found THEN

Line 6908: FROM fem_value_sets_b

6904: IF (ta_attr_assign_vs_dc(j) IS NOT NULL) THEN
6905: BEGIN
6906: SELECT value_set_id
6907: INTO ta_attr_assign_vs_id(j)
6908: FROM fem_value_sets_b
6909: WHERE value_set_display_code = ta_attr_assign_vs_dc(j)
6910: AND dimension_id = ta_attribute_dimension_id(j);
6911: EXCEPTION
6912: WHEN no_data_found THEN

Line 8063: v_vs_table := ', FEM_VALUE_SETS_B V1';

8059:
8060: v_vs_col := ',B.value_set_display_code, V1.value_set_id ';
8061: v_vs_t_where_cond := ' AND B.value_set_display_code = T.value_set_display_code';
8062:
8063: v_vs_table := ', FEM_VALUE_SETS_B V1';
8064: v_vs_where_cond := ' AND B.value_set_display_code = V1.value_set_display_code (+)'||
8065: ' AND V1.dimension_id (+) = '||p_dimension_id;
8066:
8067: v_vs_subq_table := ', FEM_VALUE_SETS_B V2';

Line 8067: v_vs_subq_table := ', FEM_VALUE_SETS_B V2';

8063: v_vs_table := ', FEM_VALUE_SETS_B V1';
8064: v_vs_where_cond := ' AND B.value_set_display_code = V1.value_set_display_code (+)'||
8065: ' AND V1.dimension_id (+) = '||p_dimension_id;
8066:
8067: v_vs_subq_table := ', FEM_VALUE_SETS_B V2';
8068: v_vs_subq_where_cond := ' AND G.value_set_id = V2.value_set_id AND '||
8069: 'V2.value_set_display_code = B.value_set_display_code';
8070: ELSE
8071:

Line 8350: v_vs_from_cond := ',fem_value_sets_b V ';

8346: v_dim_label_where_cond := '';
8347: END IF;
8348:
8349: IF p_value_set_required_flag = 'Y' and p_load_type NOT IN ('DIMENSION_GROUP') THEN
8350: v_vs_from_cond := ',fem_value_sets_b V ';
8351: v_vs_where_cond := ' AND V.value_set_display_code = B.value_set_display_code'||
8352: ' AND V.value_set_id = G.value_set_id'||
8353: ' AND V.dimension_id = '||p_dimension_id;
8354: ELSE

Line 8506: v_vs_table := ', FEM_VALUE_SETS_B V1';

8502:
8503: v_vs_col := ',B.value_set_display_code ';
8504: v_vs_t_where_cond := ' AND B.value_set_display_code = T.value_set_display_code';
8505:
8506: v_vs_table := ', FEM_VALUE_SETS_B V1';
8507: v_vs_where_cond := ' AND B.value_set_display_code = V1.value_set_display_code (+)';
8508:
8509: v_vs_subq_table := ', FEM_VALUE_SETS_B V2';
8510: v_vs_subq_where_cond := ' AND G.value_set_id = V2.value_set_id AND '||

Line 8509: v_vs_subq_table := ', FEM_VALUE_SETS_B V2';

8505:
8506: v_vs_table := ', FEM_VALUE_SETS_B V1';
8507: v_vs_where_cond := ' AND B.value_set_display_code = V1.value_set_display_code (+)';
8508:
8509: v_vs_subq_table := ', FEM_VALUE_SETS_B V2';
8510: v_vs_subq_where_cond := ' AND G.value_set_id = V2.value_set_id AND '||
8511: 'V2.value_set_display_code = B.value_set_display_code';
8512: v_vs_subq_where_condB2 := ' AND B2.value_set_display_code = B.value_set_display_code';
8513:

Line 9323: ', fem_value_sets_b V'||

9319: ',last_updated_by = '||gv_apps_user_id||
9320: ',last_update_login = '||gv_login_id||
9321: ' WHERE '||p_member_col||' = (SELECT '||p_member_col||
9322: ' FROM '||p_target_b_table||' T'||
9323: ', fem_value_sets_b V'||
9324: ' WHERE to_char(T.'||p_member_dc_col||') = :b_member_display_code'||
9325: ' AND T.value_set_id = V.value_set_id'||
9326: ' AND V.value_set_display_code = :b_value_set_display_code)'||
9327: ' AND value_set_id = (SELECT value_set_id FROM FEM_VALUE_SETS_B'||

Line 9327: ' AND value_set_id = (SELECT value_set_id FROM FEM_VALUE_SETS_B'||

9323: ', fem_value_sets_b V'||
9324: ' WHERE to_char(T.'||p_member_dc_col||') = :b_member_display_code'||
9325: ' AND T.value_set_id = V.value_set_id'||
9326: ' AND V.value_set_display_code = :b_value_set_display_code)'||
9327: ' AND value_set_id = (SELECT value_set_id FROM FEM_VALUE_SETS_B'||
9328: ' WHERE value_set_display_code = :b_value_set_display_code)'||
9329: ' AND :b_t_a_status = ''LOAD''';
9330:
9331:

Line 9426: ' FROM fem_value_sets_b '||

9422: IF p_calling_mode = 'NEW_MEMBERS' THEN
9423: IF p_value_set_required_flag = 'Y'
9424: AND p_load_type NOT IN ('DIMENSION_GROUP') THEN
9425: v_vs_where_cond := ' AND value_set_id = (SELECT value_set_id'||
9426: ' FROM fem_value_sets_b '||
9427: ' WHERE value_set_display_code = :vs_dc)';
9428: ELSE v_vs_where_cond := '';
9429: END IF;
9430:

Line 9440: ' FROM fem_value_sets_b '||

9436: IF p_value_set_required_flag = 'Y'
9437: AND p_load_type NOT IN ('DIMENSION_GROUP') THEN
9438: v_vs_where_cond := ' AND B.value_set_id = T.value_set_id'||
9439: ' AND B.value_set_id = (SELECT value_set_id'||
9440: ' FROM fem_value_sets_b '||
9441: ' WHERE value_set_display_code = :vs_dc)';
9442: ELSE v_vs_where_cond := '';
9443: END IF;
9444:

Line 9554: ',fem_value_sets_b V'||

9550: ',last_updated_by = :b_apps_user_id'||
9551: ',last_update_login = :b_login_id'||
9552: ' WHERE '||p_member_col||' = (SELECT T.'||p_member_col||
9553: ' FROM '||p_target_b_table||' T'||
9554: ',fem_value_sets_b V'||
9555: ' WHERE to_char(T.'||p_member_dc_col||') = :b_member_display_code'||
9556: ' AND T.value_set_id = V.value_set_id'||
9557: ' AND V.value_set_display_code = :b_value_set_display_code'||
9558: ')'||

Line 9559: ' AND value_set_id = (SELECT value_set_id FROM FEM_VALUE_SETS_B'||

9555: ' WHERE to_char(T.'||p_member_dc_col||') = :b_member_display_code'||
9556: ' AND T.value_set_id = V.value_set_id'||
9557: ' AND V.value_set_display_code = :b_value_set_display_code'||
9558: ')'||
9559: ' AND value_set_id = (SELECT value_set_id FROM FEM_VALUE_SETS_B'||
9560: ' WHERE value_set_display_code = :b_value_set_display_code)'||
9561: ' AND language = :b_language'||
9562: ' AND :b_status = ''LOAD''';
9563:

Line 9745: ', fem_value_sets_b V2'||

9741: ' WHERE B.status'||p_exec_mode_clause||
9742: ' AND {{data_slice}} '||
9743: ') T2'||
9744: ', '||p_target_b_table||' M2'||
9745: ', fem_value_sets_b V2'||
9746: ' WHERE T2.attribute_varchar_label'||v_outer_join||' = A1.attribute_varchar_label '||
9747: ' AND B1.dimension_id = A1.dimension_id'||
9748: ' AND B1.dimension_varchar_label = '''||p_dimension_varchar_label||''''||
9749: ' AND T2.version_display_code = V1.version_display_code'||

Line 9975: v_vs_table := ', fem_value_sets_b V2';

9971: v_value_set_select_T1 := ', T1.value_set_display_code';
9972: v_value_set_select_T2 := ', T2.value_set_display_code';
9973: v_vs_where_M2 := ' AND M2.value_set_id = V2.value_set_id '||
9974: ' AND V2.value_set_display_code = T2.value_set_display_code';
9975: v_vs_table := ', fem_value_sets_b V2';
9976:
9977:
9978: ELSE
9979: v_value_set_where_cond := '';

Line 10328: ', fem_value_sets_b V2'||

10324: ' WHERE B.status'||p_exec_mode_clause||
10325: ' AND {{data_slice}} '||
10326: ') T2'||
10327: ', '||p_target_b_table||' M2'||
10328: ', fem_value_sets_b V2'||
10329: ' WHERE T2.attribute_varchar_label'||v_outer_join||' = A1.attribute_varchar_label '||
10330: ' AND B1.dimension_id = A1.dimension_id'||
10331: ' AND B1.dimension_varchar_label = '''||p_dimension_varchar_label||''''||
10332: ' AND T2.version_display_code = V1.version_display_code'||

Line 10402: ', fem_value_sets_b V2'||

10398: ' WHERE B.status'||p_exec_mode_clause||
10399: ' AND {{data_slice}} '||
10400: ') T2'||
10401: ', '||p_target_b_table||' M2'||
10402: ', fem_value_sets_b V2'||
10403: ' WHERE T2.attribute_varchar_label'||v_outer_join||' = A1.attribute_varchar_label '||
10404: ' AND B1.dimension_id = A1.dimension_id'||
10405: ' AND B1.dimension_varchar_label = '''||p_dimension_varchar_label||''''||
10406: ' AND T2.version_display_code = V1.version_display_code'||

Line 10871: ',fem_value_sets_b V'||

10867: ' AND B.version_display_code = V.version_display_code'||
10868: ' AND V.attribute_id = A.attribute_id'||
10869: ' AND NOT EXISTS (SELECT 0'||
10870: ' FROM '||p_target_b_table||' T'||
10871: ',fem_value_sets_b V'||
10872: ' WHERE T.value_set_id = V.value_set_id'||
10873: ' AND V.value_set_display_code = B.value_set_display_code'||
10874: ' AND T.'||p_member_dc_col||' = B.'||p_member_t_dc_col||')'||
10875: ' AND ((A.attribute_required_flag = ''N'')'||

Line 11056: v_value_set_table := ',fem_value_sets_b V ';

11052: ' AND A.value_set_id = V.value_set_id'||
11053: ' AND V.value_set_display_code = :b_value_set_dc'||
11054: ' AND A.value_set_id = B.value_set_id'; */
11055:
11056: v_value_set_table := ',fem_value_sets_b V ';
11057: ELSE
11058: v_value_set_where_cond := '';
11059: v_value_set_table := '';
11060: END IF;

Line 11131: v_value_set_table := ',fem_value_sets_b V ';

11127: 'Begin Build SQL statement to identify if attribute assignment already exists for multi-assign attributes');
11128:
11129: IF p_value_set_required_flag = 'Y' THEN
11130: v_value_set_where_cond := ' and A.value_set_id = :b_value_set_id';
11131: v_value_set_table := ',fem_value_sets_b V ';
11132: ELSE
11133: v_value_set_where_cond := '';
11134: v_value_set_table := '';
11135: END IF;

Line 11215: v_value_set_table := ',fem_value_sets_b V ';

11211: IF p_value_set_required_flag = 'Y' THEN
11212: v_value_set_where_cond := ' AND A.value_set_id = V.value_set_id'||
11213: ' AND V.value_set_display_code = :b_value_set_dc'||
11214: ' AND A.value_set_id = B.value_set_id';
11215: v_value_set_table := ',fem_value_sets_b V ';
11216: ELSE
11217: v_value_set_where_cond := '';
11218: v_value_set_table := '';
11219: END IF;

Line 11470: v_value_set_table := ', FEM_VALUE_SETS_B V1';

11466:
11467: IF (p_value_set_required_flag = 'Y') THEN
11468: v_value_set_where_cond := ' AND V1.value_set_id = B1.value_set_id '||
11469: ' AND V1.value_set_display_code = :b_value_set_display_code';
11470: v_value_set_table := ', FEM_VALUE_SETS_B V1';
11471:
11472: ELSE
11473: v_value_set_where_cond := '';
11474: v_value_set_table := '';

Line 11591: ', fem_value_sets_b V'||

11587: ' AND S1.value_set_display_code = B.value_set_display_code'||
11588: ' AND S1.status'||p_exec_mode_clause||')'||
11589: ' AND NOT EXISTS (SELECT 0 FROM '||
11590: p_target_b_table||' G'||
11591: ', fem_value_sets_b V'||
11592: ' WHERE to_char(G.'||p_member_dc_col||') = B.'||p_member_t_dc_col||
11593: ' AND G.value_set_id = V.value_set_id'||
11594: ' AND V.value_set_display_code = B.value_set_display_code)';
11595: ELSIF (p_load_type = 'DIMENSION_MEMBER')

Line 12039: v_value_set_table := ', FEM_VALUE_SETS_B V1';

12035: v_value_set_column := ', value_set_id';
12036: v_value_set_select := ', V1.value_set_id';
12037: v_value_set_where_cond := ' AND B1.value_set_id = V1.value_set_id '||
12038: ' AND V1.value_set_display_code = :b_value_set_display_code';
12039: v_value_set_table := ', FEM_VALUE_SETS_B V1';
12040: ELSE
12041: v_value_set_parm := '';
12042: v_value_set_column := '';
12043: v_value_set_select := '';

Line 12653: ', FEM_VALUE_SETS_B V'||

12649: ',null'||
12650: ', ''LOAD'' '||
12651: ' FROM '||p_source_b_table||' B'||
12652: ', FEM_DIMENSION_GRPS_B D'||
12653: ', FEM_VALUE_SETS_B V'||
12654: ', '||p_target_b_table||' TB'||
12655: ' WHERE B.status'||p_exec_mode_clause||
12656: ' AND {{data_slice}} '||
12657: ' AND B.value_set_display_code = V.value_set_display_code'||

Line 12668: ' AND value_set_id = (SELECT value_set_id FROM fem_value_sets_b'||

12664: 3/16/05 commented out because doing join now to target b table
12665: ' AND EXISTS (SELECT 0'||
12666: ' FROM '||p_target_b_table||
12667: ' WHERE '||p_member_dc_col||' = B.'||p_member_t_dc_col||
12668: ' AND value_set_id = (SELECT value_set_id FROM fem_value_sets_b'||
12669: ' WHERE value_set_display_code = B.value_set_display_code))';
12670: ********************************************************/
12671:
12672: ELSIF (p_load_type = 'DIMENSION_MEMBER') AND

Line 12688: ', FEM_VALUE_SETS_B V'||

12684: ',null'||
12685: ',null'||
12686: ', ''LOAD'' '||
12687: ' FROM '||p_source_b_table||' B'||
12688: ', FEM_VALUE_SETS_B V'||
12689: ', '||p_target_b_table||' TB'||
12690: ' WHERE B.status'||p_exec_mode_clause||
12691: ' AND {{data_slice}} '||
12692: ' AND B.value_set_display_code = V.value_set_display_code'||

Line 12701: ' AND value_set_id = (SELECT value_set_id FROM fem_value_sets_b'||

12697: 3/16/05 commented out because doing join now to target b table
12698: ' AND EXISTS (SELECT 0'||
12699: ' FROM '||p_target_b_table||
12700: ' WHERE '||p_member_dc_col||' = B.'||p_member_t_dc_col||
12701: ' AND value_set_id = (SELECT value_set_id FROM fem_value_sets_b'||
12702: ' WHERE value_set_display_code = B.value_set_display_code))';
12703: ********************************************************/
12704:
12705: ELSIF (p_load_type = 'DIMENSION_MEMBER')

Line 12960: ', fem_value_sets_b V'||

12956: ',last_updated_by = '||gv_apps_user_id||
12957: ',last_update_login = '||gv_login_id||
12958: ' WHERE A.'||p_member_col||' = (SELECT '||p_member_col||
12959: ' FROM '||p_target_b_table||' B'||
12960: ', fem_value_sets_b V'||
12961: ' WHERE B.'||p_member_dc_col||' = :b_member_dc'||
12962: ' AND B.value_set_id = V.value_set_id'||
12963: ' AND V.value_set_display_code = :value_set_dc)'||
12964: ' AND A.attribute_id = :b_attribute_id'||