APPS.AMS_FULFILL_PVT SQL Statements

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

Line: 115

      SELECT inventory_item_id, inventory_item_org_id,
             pricelist_header_id , nvl(qp.currency_code,'USD') currency_code
      FROM   ams_deliverables_vl del,qp_list_headers_vl qp
      WHERE  del.deliverable_id = p_deliv_id
      AND    del.pricelist_header_id = qp.list_header_id ;

Line: 124

      SELECT inventory_item_id, inventory_item_org_id,
             pricelist_header_id , nvl(qp.currency_code,'USD') currency_code
      FROM   ams_deliverables_vl del,qp_list_headers_vl qp
      WHERE  del.deliverable_id = p_deliv_id
      AND    del.pricelist_header_id = qp.list_header_id ;

Line: 133

      SELECT  list_entry_source_system_id party_id,
              fax,
              email_address
      FROM    ams_list_entries
      WHERE   list_header_id = p_list_header_id ;

Line: 413

       SELECT sender_display_name,mail_subject,source_code, start_Date_time,mail_sender_name,reply_to_mail, owner_user_id, activity_id, printer_address, delivery_mode
       FROM   ams_campaign_schedules_b
       WHERE  schedule_id = p_schedule_id ;

Line: 419

   SELECT source_code_id
     FROM ams_source_codes
    WHERE source_code = l_id
      AND active_flag = 'Y';

Line: 426

   SELECT resource_id
     FROM ams_jtf_rs_emp_v
    WHERE user_id = p_user_id;

Line: 432

   SELECT content_item_id, citem_version_id
     FROM ibc_associations
    WHERE association_type_code = 'AMS_CSCH'
    AND associated_object_val1 = to_char(p_schedule_id);  -- fix for bug # 4145845

Line: 439

    SELECT APPLY_SUPPRESSION_FLAG
    FROM ams_list_headers_all
    WHERE arc_list_used_by = 'CSCH'
    AND list_used_by_id = p_schedule_id;

Line: 775

   SELECT object_version_number
   FROM   ams_list_headers_all
   WHERE  list_header_id = p_list_header_id ;

Line: 835

   AMS_LISTHEADER_PVT.Update_ListHeader
            ( p_api_version                      => p_api_version,
              p_init_msg_list                    => FND_API.G_FALSE,
              p_commit                           => FND_API.G_FALSE,
              p_validation_level                 => FND_API.G_VALID_LEVEL_FULL,

              x_return_status                    => x_return_status,
              x_msg_count                        => x_msg_count,
              x_msg_data                         => x_msg_data ,

              p_listheader_rec                   => l_list_rec
                );

Line: 891

       AMS_LISTHEADER_PVT.Update_ListHeader
            ( p_api_version                      => p_api_version,
              p_init_msg_list                    => FND_API.G_FALSE,
              p_commit                           => FND_API.G_FALSE,
              p_validation_level                 => FND_API.G_VALID_LEVEL_FULL,

              x_return_status                    => x_return_status,
              x_msg_count                        => x_msg_count,
              x_msg_data                         => x_msg_data ,

              p_listheader_rec                   => l_list_rec
                );

Line: 1042

   SELECT  csch.campaign_id,csch.cover_letter_id cover_letter,item.item_name name,
           csch.mail_sender_name, csch.reply_to_mail replyto_mail_id, csch.from_fax_no,
           csch.activity_type_code, csch.activity_id
   FROM    ams_campaign_schedules_b csch,jtf_amv_items_vl item
   WHERE   schedule_id = p_schedule_id
   AND     csch.cover_letter_id = item.item_id ;

Line: 1294

   SELECT  deli.jtf_amv_item_id ,
           deli.deliverable_name,
           deli.kit_flag
   FROM    ams_deliverables_vl deli,ams_deliv_kit_items kit
   WHERE   kit.deliverable_kit_id = p_deliv_id
   AND     kit.deliverable_kit_part_id = deli.deliverable_id
   AND     deli.can_fulfill_electronic_flag = 'Y' ;

Line: 1492

      SELECT jtf.file_id,jtf.file_name,
             ams.activity_type_code, ams.activity_id
      FROM   ams_campaign_schedules_b ams,jtf_amv_attachments jtf
      -- modified by soagrawa, ptendulk on 06-Sep-2001
      -- WHERE  jtf.attachment_used_by = p_arc_act
      WHERE  jtf.attachment_used_by = 'AMS_'||p_arc_act
      AND    jtf.attachment_used_by_id = ams.schedule_id
      AND    jtf.can_fulfill_electronic_flag = 'Y'
      AND    ams.schedule_id = p_act_id
      AND    jtf.attachment_type = 'FILE'  ;

Line: 1910

    SELECT  list_used_by_id,
            arc_list_used_by
    FROM    ams_list_headers_all
    WHERE   list_header_id = p_list_header_id ;

Line: 1925

    SELECT  party_id,
            fax,
            email_address,
            first_name
    FROM    ams_list_entries
    WHERE   list_header_id = p_list_header_id
    -- Following code is added by ptendulk on 01-Feb-2001
    --  Refer Bug # 1618348
    AND     enabled_flag = 'Y' ;

Line: 1942

    SELECT mail_subject,source_code
    FROM   ams_campaign_schedules_b
    WHERE  schedule_id = p_schedule_id ;

Line: 2332

   SELECT party_id, list_header_id,first_name
   FROM   ams_list_entries
   WHERE  party_id IS NOT NULL
   AND    rownum  < 2 ;

Line: 2342

   SELECT  csch.campaign_id, csch.cover_letter_id cover_letter,item.item_name name,
           csch.mail_sender_name, csch.reply_to_mail ,
           csch.mail_subject
   FROM    ams_campaign_schedules_b csch,jtf_amv_items_vl item
   WHERE   schedule_id = p_schedule_id
   AND     csch.cover_letter_id = item.item_id ;

Line: 2598

   SELECT 1
   FROM     dual
   WHERE EXISTS (SELECT 1 FROM JTF_FM_QUERY_MES
                 WHERE query_id = p_query_id
                 AND   mes_doc_id = p_item_id ) ;

Line: 2635

   INSERT INTO jtf_fm_query_mes
   (mes_doc_id, query_id,last_update_date,last_updated_by,creation_date,created_by)
   VALUES(p_item_id, p_query_id,SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id) ;