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_INTG_NEW_DIM_MEMBER_PKG dependencies on FND_FLEX_VALUES

Line 112: FND_FLEX_VALUES V,

108: :pv_user_id LAST_UPDATED_BY,
109: :pv_login_id LAST_UPDATE_LOGIN
110: FROM
111: FEM_NAT_ACCTS_B M,
112: FND_FLEX_VALUES V,
113: FEM_DIM_ATTRIBUTES_B A,
114: FEM_DIM_ATTR_VERSIONS_B AV
115: WHERE
116: M.VALUE_SET_ID = :b_driving_where_vs_id ||

Line 448: FND_FLEX_VALUES V,';

444: */
445: IF FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(1).table_validated_flag = 'N' THEN
446:
447: v_flex_value_from1 := '
448: FND_FLEX_VALUES V,';
449:
450: ELSE
451: v_flex_value_from1 := '
452: (SELECT' || '

Line 580: FND_FLEX_VALUES V,';

576: Join to Value Set table to access Segment Qualifiers
577: */
578: IF FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(FEM_INTG_DIM_RULE_ENG_PKG.pv_natural_account_segment_num).table_validated_flag = 'N' THEN
579: v_flex_value_from1 := '
580: FND_FLEX_VALUES V,';
581: ELSE
582: v_flex_value_from1 := '
583: (SELECT ' || '
584: ' || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(FEM_INTG_DIM_RULE_ENG_PKG.pv_natural_account_segment_num).vs_id || ' FLEX_VALUE_SET_ID,' || '

Line 1419: FND_FLEX_VALUES

1415: :p_vs_id VALUE_SET_ID,
1416: FLEX_VALUE_ID MEMBER_ID,
1417: FLEX_VALUE MEMBER_DISPLAY_CODE
1418: FROM
1419: FND_FLEX_VALUES
1420: WHERE
1421: FLEX_VALUE_SET_ID = :v_vs_id_b AND
1422: SUMMARY_FLAG = 'N'
1423: ) S

Line 1508: FND_FLEX_VALUES

1504: :p_vs_id VALUE_SET_ID,
1505: FLEX_VALUE_ID MEMBER_ID,
1506: FLEX_VALUE MEMBER_DISPLAY_CODE
1507: FROM
1508: FND_FLEX_VALUES
1509: WHERE
1510: FLEX_VALUE_SET_ID = :v_vs_id_b AND
1511: SUMMARY_FLAG = ''N''
1512: ) S';

Line 1525: FND_FLEX_VALUES B,

1521: T.LANGUAGE LANGUAGE_CODE,
1522: T.SOURCE_LANG
1523: FROM
1524: ' || p_member_b_table_name || ' M,
1525: FND_FLEX_VALUES B,
1526: FND_FLEX_VALUES_TL T
1527: WHERE
1528: M.VALUE_SET_ID = :p_vs_id AND
1529: T.FLEX_VALUE_ID = M.' || p_member_col || ' AND

Line 1526: FND_FLEX_VALUES_TL T

1522: T.SOURCE_LANG
1523: FROM
1524: ' || p_member_b_table_name || ' M,
1525: FND_FLEX_VALUES B,
1526: FND_FLEX_VALUES_TL T
1527: WHERE
1528: M.VALUE_SET_ID = :p_vs_id AND
1529: T.FLEX_VALUE_ID = M.' || p_member_col || ' AND
1530: B.FLEX_VALUE_ID = T.FLEX_VALUE_ID AND

Line 1586: v_member_id_val := 'FND_FLEX_VALUES_S.NEXTVAL';

1582: ) S';
1583:
1584: v_vs_id_b := '';
1585:
1586: v_member_id_val := 'FND_FLEX_VALUES_S.NEXTVAL';
1587: v_source_lang := 'S.LANGUAGE_CODE';
1588:
1589: END IF;
1590:

Line 2701: fnd_flex_values_s.nextval

2697: , last_update_login
2698: , object_version_number
2699: , read_only_flag)
2700: SELECT
2701: fnd_flex_values_s.nextval
2702: , :v_fem_vs_id
2703: , null
2704: , concat_segment_value
2705: , ''Y''

Line 2889: ||' ,fnd_flex_values flex1

2885: || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(1).table_name || ' '
2886: || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(1).where_clause || ') TL1';
2887: ELSE
2888: v_merge_stmt := v_merge_stmt
2889: ||' ,fnd_flex_values flex1
2890: ,fnd_flex_values_tl TL1';
2891: END IF;
2892:
2893: IF NVL(fem_intg_dim_rule_eng_pkg.pv_mapped_segs(2).table_validated_flag,'N') = 'Y'

Line 2890: ,fnd_flex_values_tl TL1';

2886: || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(1).where_clause || ') TL1';
2887: ELSE
2888: v_merge_stmt := v_merge_stmt
2889: ||' ,fnd_flex_values flex1
2890: ,fnd_flex_values_tl TL1';
2891: END IF;
2892:
2893: IF NVL(fem_intg_dim_rule_eng_pkg.pv_mapped_segs(2).table_validated_flag,'N') = 'Y'
2894: THEN

Line 2904: ||' ,fnd_flex_values flex2

2900: || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(2).table_name || ' '
2901: || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(2).where_clause || ') TL2';
2902: ELSE
2903: v_merge_stmt := v_merge_stmt
2904: ||' ,fnd_flex_values flex2
2905: ,fnd_flex_values_tl TL2';
2906: END IF;
2907:
2908: IF fem_intg_dim_rule_eng_pkg.pv_segment_count > 2

Line 2905: ,fnd_flex_values_tl TL2';

2901: || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(2).where_clause || ') TL2';
2902: ELSE
2903: v_merge_stmt := v_merge_stmt
2904: ||' ,fnd_flex_values flex2
2905: ,fnd_flex_values_tl TL2';
2906: END IF;
2907:
2908: IF fem_intg_dim_rule_eng_pkg.pv_segment_count > 2
2909: THEN

Line 2921: ||',fnd_flex_values flex3

2917: || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(3).table_name || ' '
2918: || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(3).where_clause || ') TL3';
2919: ELSE
2920: v_merge_stmt := v_merge_stmt
2921: ||',fnd_flex_values flex3
2922: , fnd_flex_values_tl TL3';
2923: END IF;
2924: END IF;
2925:

Line 2922: , fnd_flex_values_tl TL3';

2918: || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(3).where_clause || ') TL3';
2919: ELSE
2920: v_merge_stmt := v_merge_stmt
2921: ||',fnd_flex_values flex3
2922: , fnd_flex_values_tl TL3';
2923: END IF;
2924: END IF;
2925:
2926: IF fem_intg_dim_rule_eng_pkg.pv_segment_count > 3

Line 2939: ||',fnd_flex_values flex4

2935: || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(4).table_name || ' '
2936: || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(4).where_clause || ') TL4';
2937: ELSE
2938: v_merge_stmt := v_merge_stmt
2939: ||',fnd_flex_values flex4
2940: , fnd_flex_values_tl TL4';
2941: END IF;
2942: END IF;
2943:

Line 2940: , fnd_flex_values_tl TL4';

2936: || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(4).where_clause || ') TL4';
2937: ELSE
2938: v_merge_stmt := v_merge_stmt
2939: ||',fnd_flex_values flex4
2940: , fnd_flex_values_tl TL4';
2941: END IF;
2942: END IF;
2943:
2944: IF fem_intg_dim_rule_eng_pkg.pv_segment_count > 4

Line 2957: ||',fnd_flex_values flex5

2953: || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(5).table_name || ' '
2954: || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(5).where_clause || ') TL5';
2955: ELSE
2956: v_merge_stmt := v_merge_stmt
2957: ||',fnd_flex_values flex5
2958: ,fnd_flex_values_tl TL5';
2959: END IF;
2960: END IF;
2961:

Line 2958: ,fnd_flex_values_tl TL5';

2954: || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(5).where_clause || ') TL5';
2955: ELSE
2956: v_merge_stmt := v_merge_stmt
2957: ||',fnd_flex_values flex5
2958: ,fnd_flex_values_tl TL5';
2959: END IF;
2960: END IF;
2961:
2962: v_merge_stmt := v_merge_stmt

Line 3296: ,fnd_flex_values flex

3292: ,pv_login_id
3293: ,'N' -- Bug 4393061 - changed read_only_flag to 'N'
3294: ,1
3295: FROM fem_intg_dim_members_gt tab1
3296: ,fnd_flex_values flex
3297: WHERE dimension_id = fem_intg_dim_rule_eng_pkg.pv_com_dim_id
3298: AND flex.FLEX_VALUE_SET_ID = fem_intg_dim_rule_eng_pkg.pv_mapped_segs(1).vs_id
3299: AND flex.flex_value = tab1.concat_segment_value
3300: AND not exists ( SELECT 'x'

Line 3346: ,fnd_flex_values_tl TL

3342: ,pv_user_id
3343: ,SYSDATE
3344: ,pv_login_id
3345: FROM fem_companies_b tab1
3346: ,fnd_flex_values_tl TL
3347: WHERE tab1.value_set_id = fem_intg_dim_rule_eng_pkg.pv_com_vs_id
3348: AND tab1.company_id = TL.flex_value_id
3349: AND not exists ( SELECT 'x'
3350: FROM fem_companies_tl tab2

Line 3389: SELECT FND_FLEX_VALUES_S.nextval

3385: object_version_number,
3386: company_name,
3387: description
3388: )
3389: SELECT FND_FLEX_VALUES_S.nextval
3390: ,:v_seg1_vs_id
3391: ,concat_segment_value
3392: ,''Y''
3393: ,''N''

Line 3536: ,fnd_flex_values flex

3532: ,pv_login_id
3533: ,'N'
3534: ,1
3535: FROM fem_intg_dim_members_gt tab1
3536: ,fnd_flex_values flex
3537: WHERE dimension_id = fem_intg_dim_rule_eng_pkg.pv_dim_id /* Because dependent VS*/
3538: AND flex.FLEX_VALUE_SET_ID = fem_intg_dim_rule_eng_pkg.pv_mapped_segs(2).vs_id
3539: AND flex.parent_flex_value_low = tab1.segment1_value
3540: AND flex.flex_value = tab1.segment2_value

Line 3575: ,fnd_flex_values flex

3571: ,pv_login_id
3572: ,'N' -- Bug 4393061 - changed read_only_flag to 'N'
3573: ,1
3574: FROM fem_intg_dim_members_gt tab1
3575: ,fnd_flex_values flex
3576: WHERE dimension_id = fem_intg_dim_rule_eng_pkg.pv_cc_dim_id
3577: AND flex.FLEX_VALUE_SET_ID = fem_intg_dim_rule_eng_pkg.pv_mapped_segs(2).vs_id
3578: AND flex.flex_value = tab1.concat_segment_value
3579: AND not exists ( SELECT 'x'

Line 3625: ,fnd_flex_values_tl TL

3621: ,pv_user_id
3622: ,SYSDATE
3623: ,pv_login_id
3624: FROM fem_cost_centers_b tab1
3625: ,fnd_flex_values_tl TL
3626: WHERE tab1.value_set_id = fem_intg_dim_rule_eng_pkg.pv_cc_vs_id
3627: AND tab1.cost_center_id = TL.flex_value_id
3628: AND not exists ( SELECT 'x'
3629: FROM fem_cost_centers_tl tab2

Line 3667: SELECT FND_FLEX_VALUES_S.nextval

3663: object_version_number,
3664: cost_center_name,
3665: description
3666: )
3667: SELECT FND_FLEX_VALUES_S.nextval
3668: ,:v_seg2_vs_id
3669: ,concat_segment_value
3670: ,''Y''
3671: ,''N''

Line 4298: FND_FLEX_VALUES ff

4294: ''-1'',
4295: ''-1'',
4296: hgt.child_display_code
4297: FROM FEM_INTG_DIM_HIER_GT hgt,
4298: FND_FLEX_VALUES ff
4299: WHERE ff.flex_value_set_id = '||FEM_INTG_HIER_RULE_ENG_PKG.pv_aol_vs_id||'
4300: AND ff.flex_value = hgt.child_display_code';
4301:
4302:

Line 4323: fnd_flex_values ffv

4319: 'MERGE INTO '||FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_memb_b_tab||' b
4320: USING (SELECT gt.concat_segment_value,
4321: ffv.flex_value_id
4322: FROM fem_intg_dim_members_gt gt,
4323: fnd_flex_values ffv
4324: WHERE ffv.flex_value_set_id = :pv_aol_vs_id
4325: AND ffv.flex_value = gt.concat_segment_value) s
4326: ON (b.'||FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_memb_col||' =s.flex_value_id
4327: AND b.value_set_id = :pv_dim_vs_id)

Line 4384: fnd_flex_values_tl tl,

4380: USING (SELECT tl.flex_value_id, ffv.flex_value,
4381: tl.description,
4382: tl.language, tl.source_lang
4383: FROM fem_intg_dim_members_gt gt,
4384: fnd_flex_values_tl tl,
4385: fnd_flex_values ffv
4386: WHERE tl.flex_value_id = ffv.flex_value_id
4387: AND ffv.flex_value_set_id = :pv_aol_vs_id
4388: AND ffv.flex_value = gt.concat_segment_value) s

Line 4385: fnd_flex_values ffv

4381: tl.description,
4382: tl.language, tl.source_lang
4383: FROM fem_intg_dim_members_gt gt,
4384: fnd_flex_values_tl tl,
4385: fnd_flex_values ffv
4386: WHERE tl.flex_value_id = ffv.flex_value_id
4387: AND ffv.flex_value_set_id = :pv_aol_vs_id
4388: AND ffv.flex_value = gt.concat_segment_value) s
4389: ON (b.'||FEM_INTG_HIER_RULE_ENG_PKG.pv_dim_memb_col||' = s.flex_value_id