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_HIER_RULE_ENG_PKG dependencies on FND_FLEX_VALUE_NORM_HIERARCHY

Line 642: fnd_flex_value_norm_hierarchy vh,

638: ''Y'',
639: -1,
640: :v_dimension_group_id
641: FROM fem_intg_dim_hier_gt gt,
642: fnd_flex_value_norm_hierarchy vh,
643: fnd_flex_values ff
644: WHERE gt.child_depth_num = :v_parent_level
645: AND vh.flex_value_set_id = :pv_aol_vs_id
646: AND vh.parent_flex_value = gt.child_display_code

Line 867: fnd_flex_value_norm_hierarchy vh,

863: ''Y'',
864: -1,
865: :dgid
866: FROM fem_intg_dim_hier_gt gt,
867: fnd_flex_value_norm_hierarchy vh,
868: '||pv_dim_memb_b_tab||' m
869: WHERE vh.flex_value_set_id = '||pv_aol_vs_id||'
870: AND vh.parent_flex_value = gt.child_display_code
871: AND vh.range_attribute = ''C''

Line 1328: fnd_flex_value_norm_hierarchy vh,

1324: 'Y',
1325: -1,
1326: 'N'
1327: FROM fem_intg_dim_hier_c1_gt gt,
1328: fnd_flex_value_norm_hierarchy vh,
1329: fnd_flex_values ff
1330: WHERE gt.child_depth_num = v_parent_level
1331: AND vh.flex_value_set_id = v_aol_vs_id
1332: AND vh.parent_flex_value = gt.child_display_code

Line 1362: fnd_flex_value_norm_hierarchy vh,

1358: 'Y',
1359: -1,
1360: 'N'
1361: FROM fem_intg_dim_hier_c2_gt gt,
1362: fnd_flex_value_norm_hierarchy vh,
1363: fnd_flex_values ff
1364: WHERE gt.child_depth_num = v_parent_level
1365: AND vh.flex_value_set_id = v_aol_vs_id
1366: AND vh.parent_flex_value = gt.child_display_code

Line 1396: fnd_flex_value_norm_hierarchy vh,

1392: 'Y',
1393: -1,
1394: 'N'
1395: FROM fem_intg_dim_hier_c3_gt gt,
1396: fnd_flex_value_norm_hierarchy vh,
1397: fnd_flex_values ff
1398: WHERE gt.child_depth_num = v_parent_level
1399: AND vh.flex_value_set_id = v_aol_vs_id
1400: AND vh.parent_flex_value = gt.child_display_code

Line 1430: fnd_flex_value_norm_hierarchy vh,

1426: 'Y',
1427: -1,
1428: 'N'
1429: FROM fem_intg_dim_hier_c4_gt gt,
1430: fnd_flex_value_norm_hierarchy vh,
1431: fnd_flex_values ff
1432: WHERE gt.child_depth_num = v_parent_level
1433: AND vh.flex_value_set_id = v_aol_vs_id
1434: AND vh.parent_flex_value = gt.child_display_code

Line 1464: fnd_flex_value_norm_hierarchy vh,

1460: 'Y',
1461: -1,
1462: 'N'
1463: FROM fem_intg_dim_hier_c5_gt gt,
1464: fnd_flex_value_norm_hierarchy vh,
1465: fnd_flex_values ff
1466: WHERE gt.child_depth_num = v_parent_level
1467: AND vh.flex_value_set_id = v_aol_vs_id
1468: AND vh.parent_flex_value = gt.child_display_code

Line 1549: fnd_flex_value_norm_hierarchy vh,

1545: 'Y',
1546: -1,
1547: 'Y'
1548: FROM fem_intg_dim_hier_c1_gt gt,
1549: fnd_flex_value_norm_hierarchy vh,
1550: fnd_flex_values ff
1551: WHERE vh.flex_value_set_id = v_aol_vs_id
1552: AND vh.parent_flex_value = gt.child_display_code
1553: AND vh.range_attribute = 'C'

Line 1580: fnd_flex_value_norm_hierarchy vh,

1576: 'Y',
1577: -1,
1578: 'Y'
1579: FROM fem_intg_dim_hier_c2_gt gt,
1580: fnd_flex_value_norm_hierarchy vh,
1581: fnd_flex_values ff
1582: WHERE vh.flex_value_set_id = v_aol_vs_id
1583: AND vh.parent_flex_value = gt.child_display_code
1584: AND vh.range_attribute = 'C'

Line 1611: fnd_flex_value_norm_hierarchy vh,

1607: 'Y',
1608: -1,
1609: 'Y'
1610: FROM fem_intg_dim_hier_c3_gt gt,
1611: fnd_flex_value_norm_hierarchy vh,
1612: fnd_flex_values ff
1613: WHERE vh.flex_value_set_id = v_aol_vs_id
1614: AND vh.parent_flex_value = gt.child_display_code
1615: AND vh.range_attribute = 'C'

Line 1642: fnd_flex_value_norm_hierarchy vh,

1638: 'Y',
1639: -1,
1640: 'Y'
1641: FROM fem_intg_dim_hier_c4_gt gt,
1642: fnd_flex_value_norm_hierarchy vh,
1643: fnd_flex_values ff
1644: WHERE vh.flex_value_set_id = v_aol_vs_id
1645: AND vh.parent_flex_value = gt.child_display_code
1646: AND vh.range_attribute = 'C'

Line 1673: fnd_flex_value_norm_hierarchy vh,

1669: 'Y',
1670: -1,
1671: 'Y'
1672: FROM fem_intg_dim_hier_c5_gt gt,
1673: fnd_flex_value_norm_hierarchy vh,
1674: fnd_flex_values ff
1675: WHERE vh.flex_value_set_id = v_aol_vs_id
1676: AND vh.parent_flex_value = gt.child_display_code
1677: AND vh.range_attribute = 'C'

Line 1722: fnd_flex_value_norm_hierarchy vh

1718: -1,
1719: 'Y'
1720: FROM fem_intg_dim_hier_gt gt,
1721: FND_LOOKUPS,
1722: fnd_flex_value_norm_hierarchy vh
1723: WHERE FND_LOOKUPS.LOOKUP_TYPE = 'YES_NO'
1724: AND vh.flex_value_set_id = 1002723
1725: AND gt.hierarchy_obj_def_id = 1
1726: AND vh.parent_flex_value = gt.child_display_code

Line 1781: fnd_flex_value_norm_hierarchy vh

1777: -1,
1778: ''Y''
1779: FROM fem_intg_dim_hier_c' || pv_traversal_rarray(i_hier_ctr).display_order || '_gt gt,
1780: ' || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(i_Concat).table_name || ',
1781: fnd_flex_value_norm_hierarchy vh
1782: ';
1783: -- ending concatinated to where that was assigned above
1784: V_sql_stmt_end := '
1785: AND ' || FEM_INTG_DIM_RULE_ENG_PKG.pv_mapped_segs(i_Concat).val_col_name || '