DBA Data[Home] [Help]

APPS.BOM_IMPORT_PUB dependencies on EGO_ATTR_GROUPS_V

Line 2518: || ' FROM (SELECT attr_group_name,attr_group_disp_name FROM ego_attr_groups_v WHERE attr_group_type = '||''''|| 'BOM_COMPONENT_BASE' || ''' AND application_id = 702 ORDER BY attr_group_name) grps,'

2514: l_attr_sql := l_attr_sql || ' FROM bom_attrs_v attr, bom_components_ext_b BCEB,bom_cmp_usr_attr_interface BCUA '||l_where_clause ;
2515: --dinu_log_message(' FROM bom_attrs_v attr, bom_components_ext_b BCEB '||l_where_clause);
2516:
2517: l_attr_sql := l_attr_sql || ' UNION ALL ' || l_attr_sql1
2518: || ' FROM (SELECT attr_group_name,attr_group_disp_name FROM ego_attr_groups_v WHERE attr_group_type = '||''''|| 'BOM_COMPONENT_BASE' || ''' AND application_id = 702 ORDER BY attr_group_name) grps,'
2519: || '(SELECT attr_name,attr_display_name,database_column,attr_group_name FROM ego_attrs_v WHERE attr_group_type = '|| ''''|| 'BOM_COMPONENT_BASE' || ''' AND application_id = 702 ORDER BY attr_group_name) attrs,'
2520: || l_src_query || l_pdh_query ||
2521: ' WHERE attrs.attr_group_name = grps.attr_group_name';
2522: --dinu_log_message(' UNION ALL ' );

Line 5273: FROM ego_attr_groups_v

5269: LOOP
5270: BEGIN
5271: SELECT multi_row_code
5272: INTO l_multi_row
5273: FROM ego_attr_groups_v
5274: WHERE attr_group_name = l_attr_table(i).ATTR_GROUP_INT_NAME
5275: AND attr_group_type = 'BOM_COMPONENTMGMT_GROUP';
5276:
5277: EXCEPTION WHEN NO_DATA_FOUND THEN