APPS.FEM_DIM_UTILS_PVT dependencies on FEM_XDIM_DIMENSIONS_VL

Line 731: From fem_xdim_dimensions_vl

727: Where Dimension_Group_Id = p_dim_group_id;
728:
729: Cursor l_xdim_csr is
730: Select ATTRIBUTE_TABLE_NAME
731: From fem_xdim_dimensions_vl
732: Where dimension_id = l_dimension_id;
733:
734: BEGIN
735:

Line 825: FROM fem_xdim_dimensions_vl

821: member_col,
822: member_display_code_col,
823: member_name_col,
824: value_set_required_flag
825: FROM fem_xdim_dimensions_vl
826: WHERE dimension_varchar_label = p_dimension_varchar_label;
827:
828: BEGIN
829: IF NOT FND_API.Compatible_API_Call ( l_api_version,

Line 4939: FROM fem_xdim_dimensions_vl

4935: MEMBER_DESCRIPTION_COL,
4936: VALUE_SET_REQUIRED_FLAG,
4937: GROUP_USE_CODE,
4938: READ_ONLY_FLAG
4939: FROM fem_xdim_dimensions_vl
4940: WHERE dimension_varchar_label = p_dimension_varchar_label
4941: )
4942: LOOP
4943:

Line 8862: FROM fem_xdim_dimensions_vl

8858: MEMBER_DESCRIPTION_COL,
8859: VALUE_SET_REQUIRED_FLAG,
8860: GROUP_USE_CODE,
8861: READ_ONLY_FLAG
8862: FROM fem_xdim_dimensions_vl
8863: WHERE dimension_varchar_label = p_dimension_varchar_label
8864: )
8865: LOOP
8866:

Line 9220: FROM fem_xdim_dimensions_vl

9216: FOR l_dim_rec IN
9217: (
9218: SELECT member_vl_object_name,
9219: member_col
9220: FROM fem_xdim_dimensions_vl
9221: WHERE dimension_varchar_label = p_dimension_varchar_label
9222: )
9223: LOOP
9224:

Line 9241: FROM fem_xdim_dimensions_vl

9237: FOR l_dim_attr_rec IN
9238: (
9239: SELECT attribute_table_name,
9240: member_col
9241: FROM fem_xdim_dimensions_vl
9242: WHERE dimension_varchar_label = p_dimension_varchar_label
9243: )
9244: LOOP
9245: IF l_dim_attr_rec.attribute_table_name IS NOT NULL THEn

Line 9370: 'FROM FEM_XDIM_DIMENSIONS_VL ' ||

9366: -- Bug 3605296: Replace the variable v_xdim_meta_data_query
9367: l_xdim_meta_data_query := 'SELECT MEMBER_VL_OBJECT_NAME, ' ||
9368: 'MEMBER_NAME_COL, ' ||
9369: 'MEMBER_COL ' ||
9370: 'FROM FEM_XDIM_DIMENSIONS_VL ' ||
9371: 'WHERE DIMENSION_ID = :1 ';
9372:
9373:
9374: OPEN c_attr_version for v_attr_version_query

Line 10395: FROM Fem_Xdim_Dimensions_VL

10391: THEN
10392:
10393: SELECT default_member_display_code
10394: INTO l_uom_code
10395: FROM Fem_Xdim_Dimensions_VL
10396: WHERE dimension_varchar_label = 'UOM';
10397:
10398: IF l_uom_code IS NULL THEN
10399: FND_MESSAGE.SET_NAME('FEM','FEM_DHM_COST_OBJ_UOM_ERROR');

Line 10570: FROM Fem_Xdim_Dimensions_VL

10566:
10567: IF p_segment_3 = '-999' THEN
10568:
10569: SELECT default_member_display_code INTO l_uom_code
10570: FROM Fem_Xdim_Dimensions_VL
10571: WHERE dimension_varchar_label = 'UOM';
10572:
10573: IF l_uom_code IS NULL THEN
10574: FND_MESSAGE.SET_NAME('FEM','FEM_DHM_COST_OBJ_UOM_ERROR');