Query to get Executable, Concurrent, Application in oracle apps AOL


Below query gives the Executable, Concurrent, Application info in oracle apps AOL
select fcpv.OUTPUT_FILE_TYPE, fcpv.CONCURRENT_PROGRAM_NAME, fcpv.USER_CONCURRENT_PROGRAM_NAME, substr(fat.application_name, 0,3), EXECUTION_FILE_NAME
from FND_CONCURRENT_PROGRAMS_VL fcpv , fnd_application_tl fat , FND_EXECUTABLES_FORM_V fefv
where
fcpv.application_id = fat.application_id
and fefv.executable_id = fcpv.EXECUTABLE_ID
and fcpv.USER_CONCURRENT_PROGRAM_NAME in (
‘HW Employee Contract Extension Letter’,
‘HW Employment Letter to Embassy’
,’HW Empoyee Education Certificate Letter’,
‘HW Probation Conformation Letter’,
‘HW Salary Certificate Letter’,
‘HW Salary Increment Letter’,
‘HW Salary Increment Or Bonus Letter Report’,
‘HW Sponsorship Visa Letter to Embassy’,
‘HW To Whom it May Concern Letter’,
‘HW Promotion Conformation Letter’,
‘HW Salary Alignment letter’,
‘HW Resignation Letter to Bank’,
‘HW Experience Certificate’,
‘HW Resignation Acceptance Letter’,
‘XXHW Employee Contract Non Renewable Report’,
‘HW Bonus Letter Only’
);

Advertisements

About pacesettergraam

A good and realistic person

Posted on December 11, 2016, in OAF, Oracle, oracle apps and tagged , , . Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: