APPS.FEM_DIM_UTILS_PVT dependencies on FEM_DIM_ATTRIBUTES_VL

Line 9353: 'FROM FEM_DIM_Attributes_VL A,' ||

9349: 'To_CHAR(AV.DATE_ASSIGN_VALUE) Date_Value, ' ||
9350: 'AV.DIM_ATTRIBUTE_VARCHAR_MEMBER Dim_Varchar_Value, ' ||
9351: 'To_CHAR(AV.DIM_ATTRIBUTE_NUMERIC_MEMBER) Dim_Number_Value ' ||
9352:
9353: 'FROM FEM_DIM_Attributes_VL A,' ||
9354: p_member_attr_table_name ||' AV ' ||
9355: 'WHERE A.Attribute_Id = AV.Attribute_Id AND ' ||
9356: 'AV.Attribute_ID = :1 AND ' ||
9357: 'AV.Version_ID = :2';

Line 9604: FROM fem_dim_attributes_vl

9600: -- Cursor to determine 'Allow Multiple Assignment' flag
9601:
9602: CURSOR l_allow_multi_assgn_csr IS
9603: SELECT allow_multiple_assignment_flag, attribute_name
9604: FROM fem_dim_attributes_vl
9605: WHERE attribute_id = p_attribute_id;
9606:
9607: -- End Bug#3848813
9608:

Line 10376: fem_dim_attributes_vl ATTR,

10372: l_uom_code VARCHAR2(30);
10373:
10374: CURSOR l_uom_csr IS SELECT PROD.dim_attribute_varchar_member as UOM_CODE
10375: FROM fem_products_attr PROD,
10376: fem_dim_attributes_vl ATTR,
10377: fem_dim_attr_versions_vl ver
10378: WHERE PROD.ATTRIBUTE_ID = ATTR.ATTRIBUTE_ID
10379: AND ATTR.attribute_varchar_label = 'PRODUCT_UOM'
10380: AND ver.attribute_id = ATTR.attribute_id

Line 11167: fem_dim_attributes_vl attributes1,

11163: FROM fem_cal_periods_vl a,
11164: fem_cal_periods_attr startDate,
11165: fem_cal_periods_attr endDate,
11166: fem_cal_periods_attr adjFlag,
11167: fem_dim_attributes_vl attributes1,
11168: fem_dim_attributes_vl attributes2,
11169: fem_dim_attributes_vl attributes3
11170: WHERE a.CALENDAR_ID=p_calendar_id
11171: AND a.cal_period_id <> p_cal_period_id --Bug:4213009

Line 11168: fem_dim_attributes_vl attributes2,

11164: fem_cal_periods_attr startDate,
11165: fem_cal_periods_attr endDate,
11166: fem_cal_periods_attr adjFlag,
11167: fem_dim_attributes_vl attributes1,
11168: fem_dim_attributes_vl attributes2,
11169: fem_dim_attributes_vl attributes3
11170: WHERE a.CALENDAR_ID=p_calendar_id
11171: AND a.cal_period_id <> p_cal_period_id --Bug:4213009
11172: AND a.DIMENSION_GROUP_ID=p_dimension_group_id

Line 11169: fem_dim_attributes_vl attributes3

11165: fem_cal_periods_attr endDate,
11166: fem_cal_periods_attr adjFlag,
11167: fem_dim_attributes_vl attributes1,
11168: fem_dim_attributes_vl attributes2,
11169: fem_dim_attributes_vl attributes3
11170: WHERE a.CALENDAR_ID=p_calendar_id
11171: AND a.cal_period_id <> p_cal_period_id --Bug:4213009
11172: AND a.DIMENSION_GROUP_ID=p_dimension_group_id
11173: AND a.CAL_PERIOD_ID = startDate.CAL_PERIOD_ID

Line 11190: fem_dim_attributes_vl c

11186:
11187: CURSOR l_cur_period_csr IS SELECT a.cal_period_name
11188: FROM fem_cal_periods_vl a,
11189: fem_cal_periods_attr b,
11190: fem_dim_attributes_vl c
11191: WHERE a.calendar_id = p_calendar_id
11192: AND a.cal_period_id <> p_cal_period_id
11193: AND a.dimension_group_id = p_dimension_group_id
11194: AND a.cal_period_id = b.cal_period_id