APPS.PO_UDA_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 75

        select database_column
        from ego_attrs_v
        where ATTR_GROUP_TYPE = p_attr_group_type
        and   ATTR_GROUP_NAME = p_attr_group_name
        and   UNIQUE_KEY_FLAG = 'Y'
        order by sequence;

Line: 106

      SELECT ENTITY_CODE
      INTO  l_attr_group_Type
      FROM  PO_UDA_AG_TEMPLATES
      WHERE TEMPLATE_ID =  p_template_id;

Line: 128

            select attr_group_name, MULTI_ROW_CODE
            into l_attr_grp_name, l_multi_row_code
            from ego_attr_groups_v
            where ATTR_GROUP_TYPE = l_attr_group_Type
            and attr_group_id = l_attr_grp_id;

Line: 137

            select attr_group_id, MULTI_ROW_CODE
            into l_attr_grp_id, l_multi_row_code
            from ego_attr_groups_v
            where ATTR_GROUP_TYPE = l_attr_group_Type
            and attr_group_name = l_attr_grp_name;

Line: 162

           select database_column, application_id, attr_name, attr_id, DATA_TYPE_CODE
           into l_db_col_name, l_application_id, l_attr_int_name, l_attr_id, l_data_type_code
           from ego_attrs_v
           where attr_id = p_attr_id
           and ATTR_GROUP_NAME = l_attr_grp_name
           and ATTR_GROUP_TYPE = l_attr_group_Type;

Line: 170

           select database_column, application_id, attr_name, attr_id, DATA_TYPE_CODE
           into l_db_col_name, l_application_id, l_attr_int_name, l_attr_id, l_data_type_code
           from ego_attrs_v
           where ATTR_NAME = p_attr_int_name
           and ATTR_GROUP_NAME = l_attr_grp_name
           and ATTR_GROUP_TYPE = l_attr_group_Type;

Line: 191

   l_sql_stmt := 'select '|| l_db_col_name ||' from '||l_ext_table_name
                  ||' where attr_group_id = '|| l_attr_grp_id ;

Line: 194

   select pk1_column_name, pk2_column_name, pk3_column_name, pk4_column_name, pk5_column_name
   into l_pk1_col_name, l_pk2_col_name, l_pk3_col_name, l_pk4_col_name, l_pk5_col_name
   from fnd_objects
   where obj_name = l_db_object_name
   and rownum < 2;

Line: 532

      SELECT ENTITY_CODE
      INTO  l_attr_group_Type
      FROM  PO_UDA_AG_TEMPLATES
      WHERE TEMPLATE_ID =  p_template_id;

Line: 552

        select attr_group_id, attr_group_name, attr_group_type, application_id
        into l_attr_grp_id, l_ag_name, l_ag_type, l_appl_id
        from ego_attr_groups_v
        where ATTR_GROUP_TYPE = l_attr_group_Type
        and attr_group_name = p_attr_grp_int_name;

Line: 558

        select attr_group_id, attr_group_name, attr_group_type, application_id
        into l_attr_grp_id, l_ag_name, l_ag_type, l_appl_id
        from ego_attr_groups_v
        where ATTR_GROUP_TYPE = l_attr_group_Type
        and attr_group_id = p_attr_grp_id;

Line: 583

        select attr_id , attr_name
        into l_attr_id , l_attr_name
        from ego_attrs_v
        where attr_name = p_attr_int_name
        and attr_group_name = l_ag_name
        and attr_group_type = l_attr_group_type;

Line: 590

        select attr_id , attr_name
        into l_attr_id, l_attr_name
        from ego_attrs_v
        where attr_id = p_attr_id
        and attr_group_name = l_ag_name
        and attr_group_type = l_attr_group_type;

Line: 662

      select pk1_column_name, pk2_column_name, pk3_column_name,
             pk4_column_name, pk5_column_name
      into l_pk1_col_name, l_pk2_col_name, l_pk3_col_name,
             l_pk4_col_name, l_pk5_col_name
      from fnd_objects
      where obj_name = l_db_object_name
      and rownum < 2;

Line: 719

      select data_level_name
      into l_data_level
      from EGO_DATA_LEVEL_B
      where attr_group_type = l_attr_group_type
      AND DATA_LEVEL_NAME NOT LIKE '%ARCHIVE';