eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_LIST_SRC_TYPES_PVT SQL Statements

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

Line: 95


        SELECT SUBSTR(REPLACE(source_type_code,' ','_'),1,20), source_type_code
	FROM ams_list_src_types --ams_list_src_types_vl
         WHERE list_source_type_id =  p_list_source_type_id;

Line: 101


        SELECT list_source_field_id, field_column_name, substr(replace(source_column_name,' ','_'),1,26)
          FROM ams_list_src_fields --ams_list_src_fields_vl
         WHERE list_source_type_id = p_list_source_type_id
           AND field_column_name <> 'CUSTOMER_NAME'
           AND upper(source_column_name) not in ('PARTY_ID','PARTY_NAME')
           AND nvl(enabled_flag,'Y') = 'Y';

Line: 109


     SELECT distinct asa.sub_source_type_id
       FROM ams_list_src_fields asf,
            ams_list_src_type_assocs asa
      WHERE asa.master_source_type_id =  p_list_source_type_id
        AND asa.sub_source_type_id    =asf.list_source_type_id
        AND asf.field_column_name <> 'CUSTOMER_NAME'
        AND nvl(asf.enabled_flag,'Y') = 'Y'
        AND nvl(asa.enabled_flag,'Y') = 'Y'
	ORDER BY asa.SUB_SOURCE_TYPE_ID;

Line: 119


 SELECT aso.SUB_SOURCE_TYPE_ID
 FROM  ams_list_src_type_assocs aso
 WHERE aso.master_source_type_id = p_list_source_type_id
   AND nvl(aso.enabled_flag,'Y') = 'Y'  -- bug:4055791:musman checking for the enabled flag of the associations
           and aso.SUB_SOURCE_TYPE_ID in (
               SELECT distinct asa.sub_source_type_id
                 FROM ams_list_src_fields_vl asf,
                      ams_list_src_type_assocs asa,
                      ams_list_src_types_vl ast
                WHERE asa.master_source_type_id = aso.master_source_type_id
                  AND asa.sub_source_type_id    = aso.SUB_SOURCE_TYPE_ID
                  AND asa.sub_source_type_id    = asf.list_source_type_id
                  AND asa.sub_source_type_id    = ast.list_source_type_id
                  AND asf.field_column_name <> 'CUSTOMER_NAME'
                  AND nvl(asa.enabled_flag,'Y') = 'Y'  -- bug:4055791:musman checking for the enabled flag of the associations
                  AND nvl(asf.enabled_flag,'Y') = 'Y')
        ORDER BY aso.SUB_SOURCE_TYPE_ID;

Line: 140


   SELECT count(distinct asa.sub_source_type_id)
     FROM ams_list_src_fields asf
          ,ams_list_src_type_assocs asa
    WHERE asa.master_source_type_id =  p_list_source_type_id
    AND asa.sub_source_type_id    = asf.list_source_type_id
    AND asf.field_column_name <> 'CUSTOMER_NAME'
    AND nvl(asf.enabled_flag,'Y') = 'Y'
    AND nvl(asa.enabled_flag,'Y') = 'Y';

Line: 150


        SELECT count(*) FROM  ams_list_src_type_assocs aso
        WHERE aso.master_source_type_id = p_list_source_type_id
          AND nvl(aso.enabled_flag,'Y') = 'Y'  -- bug:4055791:musman checking for the enabled flag of the associations
           and aso.SUB_SOURCE_TYPE_ID in (
               SELECT distinct asa.sub_source_type_id
                 FROM ams_list_src_fields_vl asf,
                      ams_list_src_type_assocs asa,
                      ams_list_src_types_vl ast
                WHERE asa.master_source_type_id = aso.master_source_type_id
                  AND asa.sub_source_type_id    = aso.SUB_SOURCE_TYPE_ID
                  AND asa.sub_source_type_id    = asf.list_source_type_id
                  AND asa.sub_source_type_id    = ast.list_source_type_id
                  AND nvl(asa.enabled_flag,'Y') = 'Y'  -- bug:4055791:musman checking for the enabled flag of the associations
                  AND asf.field_column_name <> 'CUSTOMER_NAME'
                  AND nvl(asf.enabled_flag,'Y') = 'Y');

Line: 169


        SELECT list_source_type_id FROM ams_list_src_types_vl WHERE source_type_code = 'FAX';

Line: 172


 SELECT asf.list_source_field_id, asf.field_column_name, substr(replace(asf.source_column_name,' ','_'),1,26)||'_S'||to_char(i_number)
   FROM ams_list_src_fields asf,
        ams_list_src_type_assocs asa
  WHERE asa.master_source_type_id = p_list_source_type_id
    AND asa.sub_source_type_id    = L_SUB_SOURCE_TYPE_ID
    AND asa.sub_source_type_id    = asf.list_source_type_id
    AND asf.field_column_name <> 'CUSTOMER_NAME'
    AND nvl(asa.enabled_flag,'Y') = 'Y'
    AND nvl(asf.enabled_flag,'Y') = 'Y';

Line: 182


  SELECT asf.list_source_field_id, asf.field_column_name, substr(replace(asf.source_column_name,' ','_'),1,26)||'_S'||to_char(i_number)
          FROM ams_list_src_fields_vl asf,
               ams_list_src_type_assocs asa,
               ams_list_src_types_vl ast
         WHERE asa.master_source_type_id = p_list_source_type_id
           AND asa.sub_source_type_id    = L_SUB_SOURCE_TYPE_ID
           AND asa.sub_source_type_id    = asf.list_source_type_id
           AND asa.sub_source_type_id    = ast.list_source_type_id
           AND asf.field_column_name <> 'CUSTOMER_NAME'
           AND nvl(asa.enabled_flag,'Y') = 'Y'  --bug:4055791:musman checking for the enabled flag of the associations
           AND nvl(asf.enabled_flag,'Y') = 'Y';

Line: 197


   SELECT count(*)
   FROM ams_list_src_fields asf,
        ams_list_src_type_assocs asa
  WHERE asa.master_source_type_id = p_list_source_type_id
    AND asa.sub_source_type_id    = L_SUB_SOURCE_TYPE_ID
    AND asa.sub_source_type_id    = asf.list_source_type_id
    AND asf.field_column_name <> 'CUSTOMER_NAME'
    AND nvl(asf.enabled_flag,'Y') = 'Y'
    AND nvl(asa.enabled_flag,'Y') = 'Y';

Line: 207


  SELECT count(*)
          FROM ams_list_src_fields_vl asf,
               ams_list_src_type_assocs asa,
               ams_list_src_types_vl ast
         WHERE asa.master_source_type_id = p_list_source_type_id
           AND asa.sub_source_type_id    = L_SUB_SOURCE_TYPE_ID
           AND asa.sub_source_type_id    = asf.list_source_type_id
           AND asa.sub_source_type_id    = ast.list_source_type_id
           AND asf.field_column_name <> 'CUSTOMER_NAME'
           AND nvl(asf.enabled_flag,'Y') = 'Y'
           AND nvl(asa.enabled_flag,'Y') = 'Y';  --bug:4055791:musman checking for the enabled flag of the associations

Line: 222


       SELECT COUNT(*)
          FROM ams_list_src_fields_vl asf,
               ams_list_src_type_assocs asa,
               ams_list_src_types_vl ast
         WHERE asa.master_source_type_id = p_list_source_type_id
           AND asa.sub_source_type_id    = asf.list_source_type_id
           AND asa.sub_source_type_id    = ast.list_source_type_id
           AND NVL(asf.enabled_flag,'Y') = 'Y'
           AND SUBSTR(asf.source_column_name,1,28) = i_st_source;

Line: 234


        SELECT 'Y'
          FROM ams_list_src_fields --ams_list_src_fields_vl
         WHERE list_source_type_id = p_list_source_type_id
           AND field_column_name <> 'CUSTOMER_NAME'
                 AND upper(source_column_name) not in ('PARTY_ID','PARTY_NAME')
           AND nvl(enabled_flag,'Y') = 'Y'
           AND ROWNUM < 2;

Line: 243


       SELECT 'Y'
          FROM ams_list_src_fields asf, --ams_list_src_fields_vl asf,
               ams_list_src_type_assocs asa
         WHERE asa.master_source_type_id = p_list_source_type_id
           AND asa.sub_source_type_id    = asf.list_source_type_id
           AND NVL(asf.enabled_flag,'Y') = 'Y'
           AND nvl(asa.enabled_flag,'Y') = 'Y'  --bug:4055791:musman checking for the enabled flag of the associations
                   AND ROWNUM < 2;

Line: 253


        SELECT 'Y'
          FROM ams_list_src_fields_vl
         WHERE list_source_type_id = p_list_source_type_id
           AND nvl(enabled_flag,'Y') = 'Y'
           AND substr(source_column_name,1,28) = i_mst_source ;

Line: 311


   i_sql_string := ' CREATE OR REPLACE VIEW '||i_view_name||' AS SELECT ';

Line: 315


   i_sql_string := i_sql_string||'LIST_SELECT_ACTION_ID LIST_SELECT_ACTION_ID  , ';

Line: 332


   i_sql_string := i_sql_string||'NEWLY_UPDATED_flag  NEWLY_UPDATED_flag   , ';

Line: 372


      I_LIST_SOURCE_FIELD_ID.DELETE;

Line: 373


      I_COLUMN_NAME.DELETE;

Line: 374


      I_COLUMN_HEADING.DELETE;

Line: 529


PROCEDURE update_all_master_views(
   p_api_version       IN  NUMBER,
   p_init_msg_list     IN  VARCHAR2  := FND_API.g_false,
   p_validation_level  IN  NUMBER    := FND_API.g_valid_level_full,
   x_return_status     OUT NOCOPY VARCHAR2,
   x_msg_count         OUT NOCOPY NUMBER,
   x_msg_data          OUT NOCOPY VARCHAR2,
   p_list_source_type_id  IN NUMBER
                      ) IS

 i_master_source_type_id        NUMBER;

Line: 542


        SELECT master_source_type_id
        FROM ams_list_src_type_assocs
        WHERE sub_source_type_id = p_list_source_type_id
         -- AND enabled_flag = 'Y'     --we have to re-generate the parent after assoc is disabled
          AND master_source_type_id in (14,30)  ; --- only if the master is person or organization contact

Line: 696


end update_all_master_views;

Line: 722


        SELECT list_source_type, master_source_type_flag FROM ams_list_src_types_vl
         WHERE list_source_type_id = p_list_source_type_id;

Line: 782


           AMS_UTILITY_PVT.debug_message(AMS_LOG_STATEMENT,g_module_name||'.'||l_api_name,'calling the update_all_master_views');

Line: 785


        update_all_master_views(
          l_api_version,
          FND_API.G_FALSE,
          FND_API.G_VALID_LEVEL_FULL,
          x_return_status,
          x_msg_count,
          x_msg_data,
          p_list_source_type_id);

Line: 815


        update_all_master_views(p_list_source_type_id);