DBA Data[Home] [Help]

APPS.BOM_IMPORT_PUB dependencies on EGO_ATTR_GROUPS_V

Line 2663: || ' 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,'

2659: 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 ;
2660: --dinu_log_message(' FROM bom_attrs_v attr, bom_components_ext_b BCEB '||l_where_clause);
2661:
2662: l_attr_sql := l_attr_sql || ' UNION ALL ' || l_attr_sql1
2663: || ' 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,'
2664: || '(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,'
2665: || l_src_query || l_pdh_query ||
2666: ' WHERE attrs.attr_group_name = grps.attr_group_name';
2667: --dinu_log_message(' UNION ALL ' );

Line 5665: FROM ego_attr_groups_v

5661: LOOP
5662: BEGIN
5663: SELECT multi_row_code
5664: INTO l_multi_row
5665: FROM ego_attr_groups_v
5666: WHERE attr_group_name = l_attr_table(i).ATTR_GROUP_INT_NAME
5667: AND attr_group_type = 'BOM_COMPONENTMGMT_GROUP';
5668:
5669: EXCEPTION WHEN NO_DATA_FOUND THEN