DBA Data[Home] [Help]

APPS.FEM_COMP_DIM_MEMBER_LOADER_PKG dependencies on FEM_DIM_ATTR_VERSIONS_VL

Line 1389: ,fem_dim_attr_versions_vl v

1385: ,v.version_id
1386: ,a.attribute_varchar_label
1387: ,a.dimension_id
1388: FROM fem_dim_attributes_vl a
1389: ,fem_dim_attr_versions_vl v
1390: WHERE a.attribute_id = v.attribute_id
1391: AND v.default_version_flag = 'Y'
1392: AND (
1393: (a.attribute_varchar_label IN ('COST_OBJECT_UNIT_FLAG','DATA_TYPE_CODE')

Line 2138: fem_dim_attr_versions_vl ver

2134: SELECT prod.dim_attribute_varchar_member AS uom_code
2135: INTO t_uom_code(j)
2136: FROM fem_products_attr prod,
2137: fem_dim_attributes_b attr,
2138: fem_dim_attr_versions_vl ver
2139: WHERE prod.product_id = t_product_id(j)
2140: AND prod.attribute_id = attr.attribute_id
2141: AND prod.version_id = ver.version_id
2142: AND attr.attribute_varchar_label = 'PRODUCT_UOM'