APPS.AHL_PRD_LOV_SERVICE_PVT SQL Statements

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

Line: 22

select user_id from fnd_user where user_name = p_user_id;

Line: 28

select responsibility_id from fnd_responsibility_vl where responsibility_key = G_BPEL_USER_ROLE_KEY;

Line: 202

   l_sql_string := 'SELECT * FROM ( SELECT DISTINCT Rownum RN, vst.visit_id,';

Line: 215

   l_sql_string := l_sql_string || ' vst.status_code not in ( ''PLANNING'', ''DELETED'' ) AND ';

Line: 507

   l_sql_string := 'SELECT * FROM ( SELECT DISTINCT Rownum RN, U.UNIT_CONFIG_HEADER_ID UC_HEADER_ID,';

Line: 775

   l_sql_string := 'SELECT * FROM ( SELECT DISTINCT Rownum RN, PF.EMPLOYEE_NUM EMPLOYEE_NUMBER,';

Line: 1064

   l_sql_string := 'SELECT * FROM ( SELECT rownum RN, bdri.resource_id ,pf.employee_num,pf.full_name, bdri.department_id,pf.employee_id ';

Line: 1285

   l_sql_string := 'SELECT rownum , meaning,STATUS_CODE FROM ( select DISTINCT FND.MEANING meaning, SOR.NEXT_STATUS_CODE STATUS_CODE ';

Line: 1514

   l_sql_string := 'SELECT * FROM ( SELECT Rownum RN, WORKORDER_OPERATION_ID, ';

Line: 1802

   l_sql_string := 'SELECT * FROM ( SELECT Rownum RN, ';

Line: 2072

   l_sql_string := 'SELECT * FROM ( SELECT DISTINCT Rownum RN, ATA_meaning, ATA_Desc, position_ref_meaning, position_key,uc.name ';

Line: 2304

   l_sql_string := 'SELECT * FROM ( SELECT DISTINCT Rownum RN, ATA_meaning, position_ref_desc, position_ref_meaning, position_key,uc.name ';

Line: 2523

   l_sql_string := 'SELECT * FROM ( SELECT DISTINCT Rownum RN, bdri.SERIAL_NUMBER,';

Line: 2753

   l_sql_string := 'SELECT * FROM ( SELECT DISTINCT Rownum RN, bdri.SERIAL_NUMBER,';

Line: 2992

   l_sql_string := 'SELECT * FROM ( SELECT DISTINCT Rownum RN, bdri.SERIAL_NUMBER,';

Line: 3212

   l_sql_string := 'SELECT * FROM ( SELECT Rownum RN,  status_id,';

Line: 3419

   l_sql_string := 'SELECT * FROM ( SELECT Rownum RN,  reason_name,';

Line: 3616

   l_sql_string := 'SELECT * FROM ( SELECT Rownum RN,  meaning,';

Line: 3800

   l_sql_string := 'SELECT * FROM ( SELECT Rownum RN,  meaning,';

Line: 3984

   l_sql_string := 'SELECT * FROM ( SELECT Rownum RN,  description,';

Line: 3990

   l_sql_string := l_sql_string || ' and ((NOT EXISTS (SELECT 1 FROM CS_SR_PROB_CODE_MAPPING_V WHERE INCIDENT_TYPE_ID = FND_PROFILE.Value(''AHL_PRD_SR_TYPE'') ';

Line: 3992

   l_sql_string := l_sql_string || ' OR (EXISTS (SELECT 1 FROM CS_SR_PROB_CODE_MAPPING_V MAP WHERE MAP.INCIDENT_TYPE_ID = FND_PROFILE.Value(''AHL_PRD_SR_TYPE'') ';

Line: 4183

   l_sql_string := 'SELECT * FROM ( SELECT Rownum RN,  name,';

Line: 4402

   l_sql_string := 'SELECT * FROM ( SELECT Rownum RN,  csi1.instance_number, csi1.lot_number,';

Line: 4407

   l_sql_string := l_sql_string || ' and csi1.INV_MASTER_ORGANIZATION_ID IN (SELECT master_organization_id ';

Line: 4638

   l_sql_string1 := 'SELECT * FROM ( SELECT Rownum RN,  mtl.concatenated_segments , mtl.description , mtl.primary_unit_of_measure, WO.workorder_id, mtl.inventory_item_id ';

Line: 4645

   l_sql_string2 := 'SELECT * FROM ( SELECT Rownum RN,  mtl.concatenated_segments , mtl.description , mtl.primary_unit_of_measure, to_number(NULL), mtl.inventory_item_id ';

Line: 4648

   l_sql_string2 := l_sql_string2 || ' and mtlp.eam_enabled_flag = ''Y'' and mtl.organization_id IN (SELECT master_organization_id ';