eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_SR_LOG_PKG SQL Statements

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

Line: 19


  select *
  from cs_incidents_diary_v
  where incident_id = p_incident_id
  and ( note_status is null or
	   note_status <> decode(c_public_notes_only,'Y','P') or
	   note_status = decode(c_public_notes_only,'N',note_status,
						'Y','P',note_status))
  order by last_update_date DESC;

Line: 29


  select *
  from cs_incidents_diary_v
  where incident_id = p_incident_id
  and ( note_status is null or
	   note_status <> decode(c_public_notes_only,'Y','P',note_status) or
	   note_status = decode(c_public_notes_only,'N',note_status,
						'Y','P',note_status))
  order by last_update_date ;

Line: 39


  select meaning
  from cs_lookups
  where lookup_type = 'CS_LOG_PARAMETERS'
  and   lookup_code = 'LOG_AUDIT'
  and   enabled_flag = 'Y'
  and   sysdate between NVL(start_date_active,sysdate) and
				    NVL(end_date_active,sysdate);

Line: 48


  select meaning
  from cs_lookups
  where lookup_type = 'CS_LOG_PARAMETERS'
  and   lookup_code = 'LOG_NOTES'
  and   enabled_flag = 'Y'
  and   sysdate between NVL(start_date_active,sysdate) and
				    NVL(end_date_active,sysdate);

Line: 57


  select meaning
  from cs_lookups
  where lookup_type = 'CS_LOG_PARAMETERS'
  and   lookup_code = 'LOG_TASKS'
  and   enabled_flag = 'Y'
  and   sysdate between NVL(start_date_active,sysdate) and
				    NVL(end_date_active,sysdate);

Line: 150


                                    i.last_update_date ,
                                    i.owner,
                                    i.old_severity_name,
			                     i.new_severity_name ,
			                     i.old_type_name     ,
			                     i.new_type_name     ,
			                     i.old_status_name   ,
                   	                i.new_status_name   ,
                   	                i.old_urgency_name  ,
                  	                i.new_urgency_name ,
                   	                i.group_old   ,
                   	                i.group_new  ,
			                     i.old_owner,
			                     i.new_owner,
                   	                i.date_old  ,
                   	                i.date_new   ,
							    i.obligation_date_new ,
	    						i.obligation_date_old,
	    						i.site_id_new ,
	    						i.site_id_old,
	    						i.old_bill_to_contact_name,
	    						i.new_bill_to_contact_name,
	    						i.old_ship_to_contact_name,
	    						i.new_ship_to_contact_name,
	    						i.old_platform_name ,
	    						i.new_platform_name,
	    						i.old_platform_version_name ,
	    						i.new_platform_version_name ,
	    						i.old_description ,
	    						i.new_description,
	    						i.old_language ,
	    						i.new_language,
			                     ls_audit_details );

Line: 190


         ls_main_field := rpad(to_char(i.last_update_date,'MM/DD/YYYY HH:MI:SS'),20,' ')||'  '||
					 rpad(i.owner,20,' ')||'  '||
                          rpad(ls_source_type_tr,20,' ')||gs_newline||i.details;

Line: 255


                                    i.last_update_date ,
                                    i.owner,
                                    i.old_severity_name,
			                     i.new_severity_name ,
			                     i.old_type_name     ,
			                     i.new_type_name     ,
			                     i.old_status_name   ,
                   	                i.new_status_name   ,
                   	                i.old_urgency_name  ,
                  	                i.new_urgency_name ,
                   	                i.group_old   ,
                   	                i.group_new  ,
			                     i.old_owner,
			                     i.new_owner,
                   	                i.date_old  ,
                   	                i.date_new   ,
							    i.obligation_date_new ,
	    						i.obligation_date_old,
	    						i.site_id_new ,
	    						i.site_id_old,
	    						i.old_bill_to_contact_name,
	    						i.new_bill_to_contact_name,
	    						i.old_ship_to_contact_name,
	    						i.new_ship_to_contact_name,
	    						i.old_platform_name ,
	    						i.new_platform_name,
	    						i.old_platform_version_name ,
	    						i.new_platform_version_name ,
	    						i.old_description ,
	    						i.new_description,
	    						i.old_language ,
	    						i.new_language,
			                     ls_audit_details );

Line: 295


         ls_main_field := rpad(to_char(i.last_update_date,'MM/DD/YYYY HH:MI:SS'),20,' ')||'  '||
					 rpad(i.owner,20,' ')||'  '||
                          rpad(ls_source_type_tr,20,' ')||gs_newline||i.details;

Line: 324


                        x_last_update_date date,
                        x_owner        varchar2,
                        x_severity_old varchar2,
	                   x_severity_new varchar2,
			         x_type_old     varchar2,
			         x_type_new     varchar2,
			         x_status_old   varchar2,
                   	    x_status_new   varchar2,
                   	    x_urgency_old  varchar2,
                        x_urgency_new  varchar2,
                  	    x_group_old    varchar2,
                   	    x_group_new    varchar2,
                   	    x_owner_old    varchar2,
                   	    x_owner_new    varchar2,
                   	    x_date_old     varchar2,
                   	    x_date_new     varchar2,
							    x_obligation_date_new   varchar2 ,
	    						x_obligation_date_old  varchar2 ,
	    						x_site_id_new   varchar2 ,
	    						x_site_id_old  varchar2 ,
	    						x_old_bill_to_contact_name  varchar2 ,
	    						x_new_bill_to_contact_name  varchar2 ,
	    						x_old_ship_to_contact_name  varchar2 ,
	    						x_new_ship_to_contact_name  varchar2 ,
	    						x_old_platform_name   varchar2 ,
	    						x_new_platform_name  varchar2 ,
	    						x_old_platform_version_name   varchar2 ,
	    						x_new_platform_version_name   varchar2 ,
	    						x_old_description   varchar2 ,
	    						x_new_description  varchar2 ,
	    						x_old_language   varchar2 ,
	    						x_new_language  varchar2 ,
			         x_details OUT VARCHAR2)
Is

  ls_details VARCHAR2(32767);

Line: 362


  select meaning
  from cs_lookups
  where lookup_type = 'CS_LOG_PARAMETERS'
  and   lookup_code = 'LOG_STATUS'
  and   enabled_flag = 'Y'
  and   sysdate between NVL(start_date_active,sysdate) and
				    NVL(end_date_active,sysdate);

Line: 371


  select meaning
  from cs_lookups
  where lookup_type = 'CS_LOG_PARAMETERS'
  and   lookup_code = 'LOG_URGENCY'
  and   enabled_flag = 'Y'
  and   sysdate between NVL(start_date_active,sysdate) and
				    NVL(end_date_active,sysdate);

Line: 381


  select meaning
  from cs_lookups
  where lookup_type = 'CS_LOG_PARAMETERS'
  and   lookup_code = 'LOG_SEVERITY'
  and   enabled_flag = 'Y'
  and   sysdate between NVL(start_date_active,sysdate) and
				    NVL(end_date_active,sysdate);

Line: 390


  select meaning
  from cs_lookups
  where lookup_type = 'CS_LOG_PARAMETERS'
  and   lookup_code = 'LOG_DATE'
  and   enabled_flag = 'Y'
  and   sysdate between NVL(start_date_active,sysdate) and
				    NVL(end_date_active,sysdate);

Line: 399


  select meaning
  from cs_lookups
  where lookup_type = 'CS_LOG_PARAMETERS'
  and   lookup_code = 'LOG_OBLIGATION_DATE'
  and   enabled_flag = 'Y'
  and   sysdate between NVL(start_date_active,sysdate) and
				    NVL(end_date_active,sysdate);

Line: 408


  select meaning
  from cs_lookups
  where lookup_type = 'CS_LOG_PARAMETERS'
  and   lookup_code = 'LOG_OWNER'
  and   enabled_flag = 'Y'
  and   sysdate between NVL(start_date_active,sysdate) and
				    NVL(end_date_active,sysdate);

Line: 417


  select meaning
  from cs_lookups
  where lookup_type = 'CS_LOG_PARAMETERS'
  and   lookup_code = 'LOG_BILL_TO_CONTACT_NAME'
  and   enabled_flag = 'Y'
  and   sysdate between NVL(start_date_active,sysdate) and
				    NVL(end_date_active,sysdate);

Line: 426


  select meaning
  from cs_lookups
  where lookup_type = 'CS_LOG_PARAMETERS'
  and   lookup_code = 'LOG_SHIP_TO_CONTACT_NAME'
  and   enabled_flag = 'Y'
  and   sysdate between NVL(start_date_active,sysdate) and
				    NVL(end_date_active,sysdate);

Line: 435


  select meaning
  from cs_lookups
  where lookup_type = 'CS_LOG_PARAMETERS'
  and   lookup_code = 'LOG_PRODUCT'
  and   enabled_flag = 'Y'
  and   sysdate between NVL(start_date_active,sysdate) and
				    NVL(end_date_active,sysdate);

Line: 444


  select meaning
  from cs_lookups
  where lookup_type = 'CS_LOG_PARAMETERS'
  and   lookup_code = 'LOG_TYPE'
  and   enabled_flag = 'Y'
  and   sysdate between NVL(start_date_active,sysdate) and
				    NVL(end_date_active,sysdate);

Line: 453


  select meaning
  from cs_lookups
  where lookup_type = 'CS_LOG_PARAMETERS'
  and   lookup_code = 'LOG_GROUP'
  and   enabled_flag = 'Y'
  and   sysdate between NVL(start_date_active,sysdate) and
				    NVL(end_date_active,sysdate);

Line: 462


  select meaning
  from cs_lookups
  where lookup_type = 'CS_LOG_PARAMETERS'
  and   lookup_code = 'LOG_LANGUAGE'
  and   enabled_flag = 'Y'
  and   sysdate between NVL(start_date_active,sysdate) and
				    NVL(end_date_active,sysdate);

Line: 471


  select meaning
  from cs_lookups
  where lookup_type = 'CS_LOG_PARAMETERS'
  and   lookup_code = 'LOG_PLATFORM'
  and   enabled_flag = 'Y'
  and   sysdate between NVL(start_date_active,sysdate) and
				    NVL(end_date_active,sysdate);

Line: 480


  select meaning
  from cs_lookups
  where lookup_type = 'CS_LOG_PARAMETERS'
  and   lookup_code = 'LOG_PLATFORM_VERSION'
  and   enabled_flag = 'Y'
  and   sysdate between NVL(start_date_active,sysdate) and
				    NVL(end_date_active,sysdate);

Line: 489


  select meaning
  from cs_lookups
  where lookup_type = 'CS_LOG_PARAMETERS'
  and   lookup_code = 'LOG_SITE'
  and   enabled_flag = 'Y'
  and   sysdate between NVL(start_date_active,sysdate) and
				    NVL(end_date_active,sysdate);

Line: 580


			      rpad(to_char(X_last_update_date,
				 'MM/DD/YYYY HH:MI:SS'),20,' ')||'  '||
				 rpad(X_owner,20,' ')||'  '||
				 rpad(l_severity||':',20,' ')||'  '||
                  rpad(NVL(X_severity_old,' '),20,' ')||' -> '||
				 rpad(NVL(X_severity_new,' '),20,' ')||gs_newline;

Line: 590


			      rpad(to_char(X_last_update_date,
				 'MM/DD/YYYY HH:MI:SS'),20,' ')||'  '||
				 rpad(X_owner,20,' ')||'  '||
				 rpad(l_status||':',20,' ')||'  '||
                  rpad(NVL(X_status_old,' '),20,' ')||' -> '||
				 rpad(NVL(X_status_new,' '),20,' ')||gs_newline;

Line: 600


			      rpad(to_char(X_last_update_date,
				 'MM/DD/YYYY HH:MI:SS'),20,' ')||'  '||
				 rpad(X_owner,20,' ')||'  '||
				 rpad(l_type||':',20,' ')||'  '||
                  rpad(NVL(X_type_old,' '),20,' ')||' -> '||
				 rpad(NVL(X_type_new,' '),20,' ')||gs_newline;

Line: 610


			       rpad(to_char(X_last_update_date,
				  'MM/DD/YYYY HH:MI:SS'),20,' ')||'  '||
				  rpad(X_owner,20,' ')||'  '||
				  rpad(l_urgency||':',20,' ')||'  '||
                   rpad(NVL(X_urgency_old,' '),20,' ')||' -> '||
				  rpad(NVL(X_urgency_new,' '),20,' ')||gs_newline;

Line: 620


			      rpad(to_char(X_last_update_date,
				 'MM/DD/YYYY HH:MI:SS'),20,' ')||'  '||
				 rpad(X_owner,20,' ')||'  '||
				 rpad(l_group||':',25,' ')||'  '||
				 rpad(NVL(X_Group_old,' '),20,' ')||' -> '||
				 rpad(NVL(X_Group_new,' '),20,' ')||gs_newline;

Line: 630


			   rpad(to_char(X_last_update_date,
			   'MM/DD/YYYY HH:MI:SS'),20,' ')||'  '||
			   rpad(X_owner,20,' ')||'  '||
			   rpad(l_owner||':',25,' ')||'  '||
               rpad(NVL(X_owner_old,' '),20,' ')||' -> '||
			   rpad(NVL(X_owner_new,' '),20,' ')||gs_newline;

Line: 640


				  rpad(to_char(X_last_update_date,
				  'MM/DD/YYYY HH:MI:SS'),20,' ')||'  '||
				  rpad(X_owner,20,' ')||'  '||
				  rpad(l_date||':',25,' ')||'  '||
                   rpad(NVL(X_Date_old,' '),20,' ')||' -> '||
				  rpad(NVL(X_Date_new,' '),20,' ')||gs_newline;

Line: 651


			    rpad(to_char(X_last_update_date,
			    'MM/DD/YYYY HH:MI:SS'),20,' ')||'  '||
			    rpad(X_owner,20,' ')||'  '||
			    rpad(l_obligation_date||
			    ':',25,' ')||'  '||
                   rpad(NVL(X_obligation_Date_old,' '),20,' ')||' -> '||
			    rpad(NVL(X_obligation_Date_new,' '),20,' ')||gs_newline;

Line: 662


			    rpad(to_char(X_last_update_date,
			    'MM/DD/YYYY HH:MI:SS'),20,' ')||'  '||
			    rpad(X_owner,20,' ')||'  '||
			    rpad(l_site||
			    ':',25,' ')||'  '||
                   rpad(NVL(X_site_id_old,' '),20,' ')||' -> '||
			    rpad(NVL(X_site_id_old,' '),20,' ')||gs_newline;

Line: 674


			    rpad(to_char(X_last_update_date,
			    'MM/DD/YYYY HH:MI:SS'),20,' ')||'  '||
			    rpad(X_owner,20,' ')||'  '||
			    rpad(l_bill_to_contact_name||
			    ':',25,' ')||'  '||
                rpad(NVL(X_old_bill_to_contact_name,' '),20,' ')||' -> '||
			    rpad(NVL(X_new_bill_to_contact_name,' '),20,' ')||
			    gs_newline;

Line: 688


			    rpad(to_char(X_last_update_date,
			    'MM/DD/YYYY HH:MI:SS'),20,' ')||'  '||
			    rpad(X_owner,20,' ')||'  '||
			    rpad(l_ship_to_contact_name||
			    ':',25,' ')||'  '||
                   rpad(NVL(X_old_ship_to_contact_name,' '),20,' ')||' -> '||
			    rpad(NVL(X_new_ship_to_contact_name,' '),20,' ')||
			    gs_newline;

Line: 701


			    rpad(to_char(X_last_update_date,
			    'MM/DD/YYYY HH:MI:SS'),20,' ')||'  '||
			    rpad(X_owner,20,' ')||'  '||
			    rpad(l_platform||
			    ':',25,' ')||'  '||
                rpad(NVL(X_old_platform_name,' '),20,' ')||' -> '||
			    rpad(NVL(X_new_platform_name,' '),20,' ')||gs_newline;

Line: 713


			    rpad(to_char(X_last_update_date,
			    'MM/DD/YYYY HH:MI:SS'),20,' ')||'  '||
			    rpad(X_owner,20,' ')||'  '||
			    rpad(l_platform_version||
			    ':',25,' ')||'  '||
                   rpad(NVL(X_old_platform_version_name,' '),20,' ')||' -> '||
			    rpad(NVL(X_new_platform_version_name,' '),20,' ')||
			    gs_newline;

Line: 727


			    rpad(to_char(X_last_update_date,
			    'MM/DD/YYYY HH:MI:SS'),20,' ')||'  '||
			    rpad(X_owner,20,' ')||'  '||
			    rpad(l_product||
			    ':',25,' ')||'  '||
                   rpad(NVL(X_old_description,' '),20,' ')||' -> '||
			    rpad(NVL(X_new_description,' '),20,' ')||
			    gs_newline;

Line: 740


			    rpad(to_char(X_last_update_date,
			    'MM/DD/YYYY HH:MI:SS'),20,' ')||'  '||
			    rpad(X_owner,20,' ')||'  '||
			    rpad(l_language||
			    ':',25,' ')||'  '||
                   rpad(NVL(X_old_language,' '),20,' ')||' -> '||
			    rpad(NVL(X_new_language,' '),20,' ')||
			    gs_newline;

Line: 760


SELECT last_update_date,notes,entered_by_name owner
FROM   jtf_notes_vl
WHERE  source_object_id = X_TASK_ID
AND    source_object_code = 'TASK'
ORDER BY 1;

Line: 767


  select meaning
  from cs_lookups
  where lookup_type = 'CS_LOG_PARAMETERS'
  and   lookup_code = 'LOG_NOTES'
  and   enabled_flag = 'Y'
  and   sysdate between NVL(start_date_active,sysdate) and
				    NVL(end_date_active,sysdate);

Line: 792


      ls_details_ind := rpad(to_char(i.last_update_date,'MM/DD/YYYY HH:MI:SS'),20,' ')||'  '||rpad(i.owner,20,' ')||'  '||rpad(l_notes,20,' ')||gs_newline||i.notes||gs_newline;