Tuesday, June 28, 2011

Apps Query

Query to update the Concurrent Prg and Executable name

fnd_concurrent_programs_vl - View
fnd_concurrent_programs_tl , fnd_concurrent_programs - Tables

Update fnd_concurrent_programs_tl
set user_concurrent_program_name = 'XXAR QMF Customer Conversion Interface'
Where Concurrent_program_id = 150490

update fnd_concurrent_programs
set concurrent_program_name = 'XXARQMF_CUST_LOAD_PRG'
Where Concurrent_program_id = 150490

===================================================================================

fnd_executables_vl - View
fnd_executables_tl , fnd_executables - Tables

Update fnd_executables_tl
Set User_executable_name = 'XXARQMF_CUST_LOAD_PRG',
Description = 'QMF Customer SQL Loader Program'
Where Application_Id = 20007 and executable_Id = 12477

Update fnd_executables
Set Executable_Name = 'XXARQMF_CUST_LOAD_PRG',
Execution_file_name = 'xxarqmf_cust_load_sh'
Where Application_Id = 20007 and executable_Id = 12477

No comments:

Post a Comment