APPS.AHL_PRD_LOV_SERVICE_PVT SQL Statements

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

Line: 169

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

Line: 182

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

Line: 474

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

Line: 742

   l_sql_string := 'SELECT ROWNUM, A.* FROM ( SELECT DISTINCT PF.EMPLOYEE_NUM EMPLOYEE_NUMBER,';

Line: 1031

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

Line: 1252

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

Line: 1432

   l_sql_string := 'SELECT rownum , meaning,lookup_code FROM ( select meaning , lookup_code  from ';

Line: 1659

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

Line: 1947

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

Line: 2217

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

Line: 2450

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

Line: 2669

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

Line: 2899

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

Line: 3138

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

Line: 3358

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

Line: 3565

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

Line: 3762

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

Line: 3946

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

Line: 4130

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

Line: 4136

   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: 4138

   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: 4329

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

Line: 4548

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

Line: 4553

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

Line: 4784

   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: 4791

   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: 4794

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