APPS.MSC_A2A_XML_WF SQL Statements

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

Line: 48

                ' select instance_code from msc_apps_instances mai '
              ||' where mai.instance_id = :instance_id' USING p_instance_id;

Line: 59

                 ' select usr.username, usr.password,'
               ||' hub.protocol_type, hub.protocol_address  '
               ||' FROM ecx_hubs hub, ecx_hub_users usr '
               ||' where hub.hub_id = usr.hub_id '
               ||' and usr.hub_entity_code = :instance_code ' USING lv_instance_code;

Line: 134

         l_parameter_list.DELETE;

Line: 148

        DELETE MSC_PO_RESCHEDULE_INTERFACE
        WHERE  purchase_order_id = p_unique_id;

Line: 152

        DELETE MSC_PO_REQUISITIONS_INTERFACE
        WHERE  source_line_id = p_unique_id;

Line: 156

        DELETE MSC_WIP_JOB_SCHEDULE_INTERFACE
        WHERE  source_line_id = p_unique_id;

Line: 159

        DELETE MSC_WIP_JOB_DTLS_INTERFACE
        WHERE  parent_header_id = p_unique_id;

Line: 163

        DELETE MSC_WIP_JOB_SCHEDULE_INTERFACE
        WHERE  source_line_id = p_unique_id;

Line: 166

        DELETE MSC_WIP_JOB_DTLS_INTERFACE
        WHERE  parent_header_id = p_unique_id;

Line: 241

           'select distinct purchase_order_id from msc_po_reschedule_interface '
         ||' where sr_instance_id = :instance_id' USING p_instance_id;

Line: 261

           'select distinct source_line_id from msc_po_requisitions_interface '
         ||' where sr_instance_id = :instance_id' USING p_instance_id;

Line: 281

           'select distinct source_line_id from msc_wip_job_schedule_interface '
         ||' where sr_instance_id = :instance_id'
         ||' and load_type in (3,6)' USING p_instance_id;

Line: 302

           'select distinct source_line_id from msc_wip_job_schedule_interface '
         ||' where sr_instance_id = :instance_id '
         ||' and load_type not in (3,6)' USING p_instance_id;