APPS.MSD_DEM_SR_UTIL SQL Statements

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

Line: 123

            SELECT multi_org_flag
               INTO x_multi_org_flag
               FROM fnd_product_groups
               WHERE product_group_type = 'Standard';

Line: 141

               SELECT organization_id
                  INTO x_master_organization
                  FROM mtl_parameters
                  WHERE organization_id = master_organization_id
                    AND rownum <2;

Line: 150

            SELECT organization_id
               INTO x_master_organization
               FROM mtl_parameters
               WHERE organization_id = master_organization_id
                 AND rownum <2;

Line: 209

        select  t.conversion_rate      std_conv_rate
        from  mtl_uom_conversions t
        where t.inventory_item_id in (p_item_id, 0)
        and   t.uom_code= p_uom_code
        and   nvl(t.disable_date, trunc(sysdate) + 1) > trunc(sysdate)
	and   t.conversion_rate is not null
        order by t.inventory_item_id desc;

Line: 234

      select to_number(parameter_value)
      into l_master_org
      from msd_dem_setup_parameters
      where parameter_name = 'MSD_DEM_MASTER_ORG';

Line: 239

     select NVL(primary_uom_code,'Ea')
     into   l_master_uom
     from mtl_system_items
     where inventory_item_id = item_id
     and   organization_id = l_master_org;

Line: 266

select 1
from
   msd_dem_app_instance_orgs morg,
   bom_bill_of_materials     bbm,
   mtl_system_items          msi,  -- Parent
   bom_inventory_components  bic
where
   bic.bill_sequence_id = bbm.bill_sequence_id
   and bbm.organization_id = morg.organization_id
   and msi.organization_id = bbm.organization_id
   and msi.inventory_item_id = bbm.assembly_item_id
   and msi.bom_item_type not in (C_PLANNING, C_STANDARD, C_PRODUCT_FAMILY)
   and bic.optional = C_YES
   and ( msi.bom_item_type = 2 or
         ( msi.bom_item_type = 1 and msi.ato_forecast_control in (1, 2) )
       )
   and bic.component_item_id = p_component_item_id;

Line: 310

SELECT
count(1)
FROM
mtl_system_items parent,
bom_inventory_components bic,
bom_bill_of_materials bom
WHERE
parent.bom_item_type = 5 and
parent.organization_id = bom.organization_id and
bom.ASSEMBLY_ITEM_ID = parent.inventory_item_id and
bom.bill_sequence_id = bic.bill_sequence_id and
bic.component_item_id = p_inventory_item_id and
bom.organization_id = p_org_id and
nvl(parent.ato_forecast_control, 3) <> 3;

Line: 364

select count(1)
from mtl_system_items itm
where inventory_item_id = (select inventory_item_id
    from oe_order_lines_all l
    where l.item_type_code = 'CONFIG'
    and l.header_id = p_header_id
    and l.org_id = p_org_id
    and l.ato_line_id = p_ato_line_id )
and itm.organization_id = p_org_id
and nvl(itm.ato_forecast_control, 3) <> 3
and itm.base_item_id is not null;

Line: 409

select parameter_value
into c_global_currency_code
from msd_dem_setup_parameters
where parameter_name = 'MSD_DEM_CURRENCY_CODE';

Line: 414

select parameter_value
into c_global_rate_type
from msd_dem_setup_parameters
where parameter_name = 'MSD_DEM_CONVERSION_TYPE';

Line: 443

select application_column_name
from fnd_descr_flex_column_usages
where end_user_column_name  = x_end_user_column_name
and descriptive_flexfield_name = x_des_fname
and application_id = x_wsh_application_id;

Line: 473

    l_sql_stmt := ' select wrv.zone ' ||
		  ' from wsh_region_locations wrl, ' ||
                  ' wsh_zone_regions wzr, ' ||
		  ' wsh_regions_v wrv ' ||
		  ' where wrl.location_id = ''' || p_location_id  || '''' ||
		  ' and wrl.region_id = wzr.region_id  ' ||
		  ' and wzr.parent_region_id = wrv.region_id ' ||
		  ' and wrv.region_type = 10  ' ||
		  ' and decode(nvl(lower(''' || p_zone_attr || ''' ), ''2''), ''attribute1'', wrv.attribute1,  ' ||
		  ' ''attribute2'', wrv.attribute2, ''attribute3'',wrv.attribute3, ''attribute4'',  ' ||
		  ' wrv.attribute4, ''attribute5'', wrv.attribute5, ''attribute6'', wrv.attribute6,  ' ||
		  ' ''attribute7'', wrv.attribute7, ''attribute8'', wrv.attribute8, ''attribute9'',  ' ||
		  ' wrv.attribute9, ''attribute10'', wrv.attribute10, ''attribute11'', wrv.attribute11,  ' ||
		  ' ''attribute12'', wrv.attribute12, ''attribute13'', wrv.attribute13, ''attribute14'',  ' ||
		  ' wrv.attribute14, ''attribute15'', wrv.attribute15, ''2'') = ''1'' ' ||
		  ' order by wrv.region_id';

Line: 506

select wrv.region_id
from wsh_region_locations wrl,
wsh_zone_regions wzr,
wsh_regions_v wrv
where wrl.location_id = p_location_id
and wrl.region_id = wzr.region_id
and wzr.parent_region_id = wrv.region_id
and wrv.region_type = 10
and decode(nvl(lower(p_zone_attr), '2'), 'attribute1', wrv.attribute1,
'attribute2', wrv.attribute2, 'attribute3',wrv.attribute3, 'attribute4',
wrv.attribute4, 'attribute5', wrv.attribute5, 'attribute6', wrv.attribute6,
'attribute7', wrv.attribute7, 'attribute8', wrv.attribute8, 'attribute9',
wrv.attribute9, 'attribute10', wrv.attribute10, 'attribute11', wrv.attribute11,
'attribute12', wrv.attribute12, 'attribute13', wrv.attribute13, 'attribute14',
wrv.attribute14, 'attribute15', wrv.attribute15, '2') = '1'
order by wrv.region_id;

Line: 548

select 1
from csd_repair_job_xref crjx
where wip_entity_id = p_txn_source_id
order by repair_job_xref_id;

Line: 576

select organization_id
from csd_repair_job_xref crjx
where wip_entity_id = p_txn_source_id
order by repair_job_xref_id desc;