query to find responsibility name from user

SELECT fu.user_name,
frt.responsibility_name,
furg.start_date,
furg.end_date,
fr.responsibility_key,
fa.application_short_name "Application Short Name"
FROM apps.fnd_user_resp_groups_direct furg,
apps.fnd_user fu,
apps.fnd_responsibility_tl frt,
apps.fnd_responsibility fr,
apps.fnd_application_tl fat,
apps.fnd_application fa
WHERE furg.user_id = fu.user_id
AND furg.responsibility_id = frt.responsibility_id
AND fr.responsibility_id = frt.responsibility_id
AND fa.application_id = fat.application_id
AND fr.application_id = fat.application_id
AND frt.language = USERENV('LANG')
AND UPPER(fu.user_name) = UPPER('SSHARMA')
ORDER BY furg.start_date;

Query to find concurrent programs using a value set in its parameter list

SELECT
fcp.user_concurrent_program_name,
fat.application_name,
fdfc.column_seq_num,
fdfc.form_left_prompt parameter_name,
fdfc.enabled_flag
FROM
apps.fnd_descr_flex_col_usage_vl fdfc,
apps.fnd_flex_value_sets ffvs,
apps.fnd_concurrent_programs_vl fcp,
apps.fnd_application_tl fat
WHERE
1 = 1
AND ffvs.flex_value_set_id = fdfc.flex_value_set_id
AND fdfc.descriptive_flexfield_name = '$SRS$.' || fcp.concurrent_program_name
AND fcp.application_id = fat.application_id
AND ffvs.flex_value_set_name = 'JEIT_CALENDAR_MONTH' --value set name

how to compile sql, pkb, ldt and wft file from shell script

#!/bin/bash

#* $Header:FACutomizationScript.sh  99.99 MM/DD/YYYY HH:MI:SS  *

########################################################################################################################

#

# Shell Script Name : XXX_CUSTOM.sh

#

# Purpose           : XXX_CUSTOM Custom Program Migration script

# Change History    : 04-Apr-2022 

#  

########################################################################################################################

APPS_USER='apps'

read -s -p "Enter Apps Password: " APPS_PASSWD

read -s -p "Enter SID: "  DB_SID

#APPS_PASSWD

#DB_SID=

date

who am i

cd $XXX_TOP/UPGRADE

echo "Compiling plsql" 

echo "Compiling view XXX_OE_PKG_SPEC.sql"

echo " "

sqlplus -s $APPS_USER/$APPS_PASSWD@$DB_SID @$XXX_TOP/R12UPGRADE/XXX_OE_PKG_SPEC.sql

echo "Compiling XXX_OE_PKG_BODY.sql"

echo " "

sqlplus -s $APPS_USER/$APPS_PASSWD@$DB_SID @$XXX_TOP/R12UPGRADE/XXX_OE_PKG_BODY.sql

echo "Executing file XXX_POXRQERQ.ldt"

echo " "

FNDLOAD $APPS_USER/$APPS_PASSWD 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct XXX_POXRQERQ.ldt

echo "Compiling XXX_Lookup_Code.sql"

echo " "

sqlplus -s $APPS_USER/$APPS_PASSWD@$DB_SID @$XXX_TOP/R12UPGRADE/XXX_Lookup_Code.sql

echo "Compiling XXX_ACCT_GEN_PKG.pks"

echo " "

sqlplus -s $APPS_USER/$APPS_PASSWD@$DB_SID @$OVT_TOP/R12UPGRADE/XXX_ACCT_GEN_PKG.pks

echo "Compiling XXX_ACCT_GEN_PKG.pkb"

echo " "

sqlplus -s $APPS_USER/$APPS_PASSWD@$DB_SID @$OVT_TOP/R12UPGRADE/XXX_ACCT_GEN_PKG.pkb

echo "copy XXXRWMO.rdf"

echo " "

cp $XXX_TOP/R12UPGRADE/XXXRWMO.rdf $XXX_TOP/reports/US

echo "copy XXXTOPKL.rdf"

echo " "

cp $XXX_TOP/R12UPGRADE/XXXTOPKL.rdf $XXX_TOP/reports/US

echo "Upload XXX_POWFACCT_MODIFIED.wft"

echo " "

WFLOAD $APPS_USER/$APPS_PASSWD 0 Y FORCE XXX_POWFACCT_MODIFIED.wft

echo "Upload XXX_CRP_V3.wft"

echo " "

WFLOAD $APPS_USER/$APPS_PASSWD 0 Y FORCE XXX_CRP_V3.wft

date

who am i

echo "End of script"

# --------------------------------------------------------------------

#  End of Script

# --------------------------------------------------------------------