DBA Data[Home] [Help]

APPS.GCS_WEBADI_PKG dependencies on FEM_DIM_ATTRIBUTES_B

Line 1271: FROM fem_xdim_dimensions fxd, fem_dim_attributes_b fdab

1267: SELECT fdab.attribute_id, fxd.member_display_code_col, fxd.member_b_table_name,
1268: fxd.member_col, fdab.default_assignment, fdab.attribute_varchar_label
1269: BULK COLLECT INTO l_attribute_id_list, l_member_display_code_list, l_member_b_table_list,
1270: l_member_col_list, l_default_assign_list, l_attr_varchar_list
1271: FROM fem_xdim_dimensions fxd, fem_dim_attributes_b fdab
1272: WHERE fxd.dimension_id (+)= fdab.attribute_dimension_id
1273: AND fdab.dimension_id = g_dimension_info(p_dimension_varchar_label).dimension_id
1274: AND fdab.attribute_required_flag = 'Y';
1275:

Line 1336: fem_dim_attributes_b fdab

1332: fdavb.version_display_code,
1333: 'LOAD'
1334: FROM gcs_dimension_members_t ,
1335: fem_dim_attr_versions_b fdavb,
1336: fem_dim_attributes_b fdab
1337: WHERE fdavb.default_version_flag = 'Y'
1338: AND fdavb.attribute_id = fdab.attribute_id
1339: AND fdab.attribute_varchar_label = 'COST_CENTER'
1340: AND fdab.dimension_id = 8

Line 1361: fem_dim_attributes_b fdab

1357: fdavb.version_display_code,
1358: 'LOAD'
1359: FROM gcs_dimension_members_t ,
1360: fem_dim_attr_versions_b fdavb,
1361: fem_dim_attributes_b fdab
1362: WHERE fdavb.default_version_flag = 'Y'
1363: AND fdavb.attribute_id = fdab.attribute_id
1364: AND fdab.attribute_varchar_label = 'COMPANY'
1365: AND fdab.dimension_id = 8