APPS.MSD_SOP_FACT_DATA SQL Statements

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

Line: 28

  select cs_definition_id
  from msd_cs_definitions
  where name = l_cs_name;

Line: 176

           select description
           into l_cs_name_desc
           from msd_cs_definitions
           where cs_definition_id = l_cs_definition_id;

Line: 184

           select MSD_CS_COLL_REQUEST_S.nextval
           into l_req_num
           from dual;

Line: 260

  select cs_definition_id
  from msd_cs_definitions
  where name in ('MSD_TOTAL_BACKLOG', 'MSD_PASTDUE_BACKLOG', 'MSD_PRODUCTION_PLAN',
                 'MSD_ACTUAL_PRODUCTION', 'MSD_ONHAND_INVENTORY');

Line: 266

  select name
  from msd_cs_definitions
  where cs_definition_id = l_cs_definition_id;

Line: 338

           select description
           into l_cs_name_desc
           from msd_cs_definitions
           where cs_definition_id = l_cs_id(j).cs_definition_id;

Line: 346

          select MSD_CS_COLL_REQUEST_S.nextval
          into l_req_num
          from dual;