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_WEBADI_MEMBER_UTILS_PVT dependencies on FEM_DIM_ATTRIBUTES_B

Line 811: , FEM_DIM_ATTRIBUTES_B A

807: , MAP.ATTRIBUTE_VARCHAR_LABEL
808: , ATTRIBUTE_REQUIRED_FLAG
809: FROM TABLE(CAST(g_changed_dt_intf_col_tbl AS FND_TABLE_OF_VARCHAR2_30)) REF
810: , FEM_WEBADI_DIM_ATTR_MAPS MAP
811: , FEM_DIM_ATTRIBUTES_B A
812: WHERE MAP.DIMENSION_VARCHAR_LABEL = p_dimension_varchar_label
813: AND MAP.INTERFACE_COL = REF.column_value
814: AND A.DIMENSION_ID = p_dimension_id
815: AND A.ATTRIBUTE_VARCHAR_LABEL = MAP.ATTRIBUTE_VARCHAR_LABEL

Line 875: , FEM_DIM_ATTRIBUTES_B A

871: , 274
872: , L.LANGUAGE_CODE
873: , B.SOURCE_LANG
874: FROM FEM_XDIM_DIMENSIONS_VL D
875: , FEM_DIM_ATTRIBUTES_B A
876: , FEM_DIM_ATTRIBUTES_TL B
877: , FND_NEW_MESSAGES M
878: , FND_LANGUAGES L
879: WHERE L.INSTALLED_FLAG IN ('I', 'B')

Line 977: , FEM_DIM_ATTRIBUTES_B A

973: , MAP.ATTRIBUTE_VARCHAR_LABEL
974: , ATTRIBUTE_REQUIRED_FLAG
975: FROM TABLE(CAST(g_changed_intf_col_tbl AS FND_TABLE_OF_VARCHAR2_30)) REF
976: , FEM_WEBADI_DIM_ATTR_MAPS MAP
977: , FEM_DIM_ATTRIBUTES_B A
978: WHERE MAP.DIMENSION_VARCHAR_LABEL = p_dimension_varchar_label
979: AND MAP.INTERFACE_COL = REF.column_value
980: AND A.DIMENSION_ID = p_dimension_id
981: AND A.ATTRIBUTE_VARCHAR_LABEL = MAP.ATTRIBUTE_VARCHAR_LABEL

Line 1042: , FEM_DIM_ATTRIBUTES_B A

1038: , 274
1039: , L.LANGUAGE_CODE
1040: , B.SOURCE_LANG
1041: FROM FEM_XDIM_DIMENSIONS_VL D
1042: , FEM_DIM_ATTRIBUTES_B A
1043: , FEM_DIM_ATTRIBUTES_TL B
1044: , FND_NEW_MESSAGES M
1045: , FND_LANGUAGES L
1046: WHERE L.INSTALLED_FLAG IN ('I', 'B')

Line 1256: , FEM_DIM_ATTRIBUTES_B A

1252: , 274
1253: , L.LANGUAGE_CODE
1254: , B.SOURCE_LANG
1255: FROM FEM_XDIM_DIMENSIONS_VL D
1256: , FEM_DIM_ATTRIBUTES_B A
1257: , FEM_DIM_ATTRIBUTES_TL B
1258: , FND_NEW_MESSAGES M
1259: , FND_LANGUAGES L
1260: WHERE L.INSTALLED_FLAG IN ('I', 'B')

Line 2989: fem_dim_attributes_b dimattr

2985: SELECT
2986: attrmap.interface_col
2987: , dimattr.attribute_data_type_code
2988: FROM
2989: fem_dim_attributes_b dimattr
2990: , fem_xdim_dimensions_vl xdim
2991: , fem_webadi_dim_attr_maps attrmap
2992: WHERE
2993: attrmap.dimension_varchar_label = p_dimension_varchar_label

Line 3008: fem_dim_attributes_b dimattr

3004: SELECT
3005: dimattr.attribute_varchar_label
3006: , dimattr.attribute_data_type_code
3007: FROM
3008: fem_dim_attributes_b dimattr
3009: , fem_xdim_dimensions_vl xdim
3010: WHERE
3011: xdim.dimension_varchar_label = p_dimension_varchar_label
3012: AND xdim.dimension_id = dimattr.dimension_id

Line 3070: -- FEM_DIM_ATTRIBUTES_B table.

3066: g_changed_intf_col_tbl := g_initialized_table ;
3067: g_changed_dt_intf_col_tbl := g_initialized_table ;
3068: --
3069: -- Delete records present in Mapping table but not in
3070: -- FEM_DIM_ATTRIBUTES_B table.
3071: DELETE
3072: FROM
3073: fem_webadi_dim_attr_maps attrmap
3074: WHERE

Line 3080: fem_dim_attributes_b attr

3076: AND attrmap.attribute_varchar_label NOT IN
3077: ( SELECT
3078: attr.attribute_varchar_label
3079: FROM
3080: fem_dim_attributes_b attr
3081: , fem_xdim_dimensions_vl xdim
3082: WHERE
3083: xdim.dimension_varchar_label = attrmap.dimension_varchar_label
3084: AND attr.dimension_id = xdim.dimension_id

Line 4065: l_attribute_dimension_id fem_dim_attributes_b.attribute_dimension_id%TYPE ;

4061: l_default_version_flag VARCHAR2(1) := 'Y' ;
4062: --
4063: l_required_flag VARCHAR2(1) := 'N' ;
4064: --
4065: l_attribute_dimension_id fem_dim_attributes_b.attribute_dimension_id%TYPE ;
4066: l_value_set_required_flag VARCHAR2(1) ;
4067: --
4068: l_attr_asgn_vs_disp_code VARCHAR2(150) := NULL ;
4069: l_attr_value_set_id NUMBER ;

Line 4080: -- fem_dim_attributes_b table.

4076: -- Find out attribute_dimension_id, version_display_code,
4077: -- attribute_value_set_required_flag.
4078: -- This information needs outer join with fem_xdim_dimensions
4079: -- table as attribute_dimension_id might be null in
4080: -- fem_dim_attributes_b table.
4081: CURSOR l_attr_csr
4082: ( dim_id NUMBER
4083: , attr_label VARCHAR2
4084: , requied_flag VARCHAR2

Line 4092: fem_dim_attributes_b Attr

4088: Attr.attribute_dimension_id
4089: , AttrVer.version_display_code
4090: , xDim.value_set_required_flag
4091: FROM
4092: fem_dim_attributes_b Attr
4093: , fem_dim_attr_versions_b AttrVer
4094: , fem_xdim_dimensions xDim
4095: WHERE
4096: Attr.dimension_id = dim_id

Line 4112: fem_dim_attributes_b dimattr

4108: SELECT
4109: dimattr.attribute_id
4110: , dimattr.attribute_required_flag
4111: FROM
4112: fem_dim_attributes_b dimattr
4113: WHERE
4114: dimattr.attribute_varchar_label = attr_label
4115: AND dimattr.dimension_id = dim_id ;
4116: --

Line 4981: fem_dim_attributes_b dimattr

4977: SELECT
4978: dimattr.attribute_id
4979: ,dimattr.attribute_required_flag, dimattr.attribute_data_type_code
4980: FROM
4981: fem_dim_attributes_b dimattr
4982: WHERE
4983: dimattr.attribute_varchar_label = attr_label
4984: AND dimattr.dimension_id = dim_id ;
4985: --