DBA Data[Home] [Help]

APPS.FND_REQUEST_INFO SQL Statements

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

Line: 136

   select
   		ARGUMENT1, ARGUMENT2, ARGUMENT3, ARGUMENT4, ARGUMENT5,
   		ARGUMENT6, ARGUMENT7, ARGUMENT8, ARGUMENT9, ARGUMENT10,
   		ARGUMENT11, ARGUMENT12, ARGUMENT13, ARGUMENT14, ARGUMENT15,
   		ARGUMENT16, ARGUMENT17, ARGUMENT18, ARGUMENT19, ARGUMENT20,
   		ARGUMENT21, ARGUMENT22, ARGUMENT23, ARGUMENT24, ARGUMENT25,
	 	 Argument26, Argument27, Argument28, Argument29, Argument30,
                 Argument31, Argument32, Argument33, Argument34, Argument35,
                 Argument36, Argument37, Argument38, Argument39, Argument40,
                 Argument41, Argument42, Argument43, Argument44, Argument45,
                 Argument46, Argument47, Argument48, Argument49, Argument50,
                 Argument51, Argument52, Argument53, Argument54, Argument55,
                 Argument56, Argument57, Argument58, Argument59, Argument60,
                 Argument61, Argument62, Argument63, Argument64, Argument65,
                 Argument66, Argument67, Argument68, Argument69, Argument70,
                 Argument71, Argument72, Argument73, Argument74, Argument75,
                 Argument76, Argument77, Argument78, Argument79, Argument80,
                 Argument81, Argument82, Argument83, Argument84, Argument85,
                 Argument86, Argument87, Argument88, Argument89, Argument90,
                 Argument91, Argument92, Argument93, Argument94, Argument95,
                 Argument96, Argument97, Argument98, Argument99, Argument100,
   		 CONCURRENT_PROGRAM_NAME, APPLICATION_SHORT_NAME, NLS_TERRITORY
   into
   		P_arg1,  P_arg2,  P_arg3,  P_arg4,  P_arg5,  P_arg6, P_arg7,
   		P_arg8,  P_arg9,  P_arg10, P_arg11, P_arg12, P_arg13, P_arg14,
   		P_arg15, P_arg16, P_arg17, P_arg18, P_arg19, P_arg20,
   		P_arg21, P_arg22, P_arg23, P_arg24, P_arg25,
                P_arg26, P_arg27, P_arg28, P_arg29, P_arg30,
		P_arg31, P_arg32, P_arg33, P_arg34, P_arg35,
		P_arg36, P_arg37, P_arg38, P_arg39, P_arg40,
		P_arg41, P_arg42, P_arg43, P_arg44, P_arg45,
		P_arg46, P_arg47, P_arg48, P_arg49, P_arg50,
		P_arg51, P_arg52, P_arg53, P_arg54, P_arg55,
		P_arg56, P_arg57, P_arg58, P_arg59, P_arg60,
		P_arg61, P_arg62, P_arg63, P_arg64, P_arg65,
		P_arg66, P_arg67, P_arg68, P_arg69, P_arg70,
		P_arg71, P_arg72, P_arg73, P_arg74, P_arg75,
		P_arg76, P_arg77, P_arg78, P_arg79, P_arg80,
		P_arg81, P_arg82, P_arg83, P_arg84, P_arg85,
		P_arg86, P_arg87, P_arg88, P_arg89, P_arg90,
		P_arg91, P_arg92, P_arg93, P_arg94, P_arg95,
		P_arg96, P_arg97, P_arg98, P_arg99, P_arg100,
   		prog_name, prog_app_name, P_nls_territory
   from  fnd_run_requests r,
         fnd_concurrent_programs p,
         fnd_application a
   where r.parent_request_id      = fnd_global.conc_request_id
     and r.concurrent_program_id  = p.concurrent_program_id
     and r.application_id         = p.application_id
     and r.application_id 	  = a.application_id;