[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT fap.application_id
,fav.application_name
,fap.application_short_name
,fou.oracle_username
,UPPER(adp.product_abbreviation)
,fou_apps.oracle_username
INTO p_application_info.application_id
,p_application_info.application_name
,p_application_info.application_short_name
,p_application_info.oracle_username
,p_application_info.product_abbreviation
,p_application_info.apps_account
FROM fnd_application fap
,fnd_application_vl fav
,fnd_product_installations fpi
,fnd_oracle_userid fou
,ad_pm_product_info adp
,fnd_oracle_userid fou_apps
WHERE fap.application_id = p_application_id
AND fav.application_id = fap.application_id
AND fpi.application_id = fap.application_id
AND fou.oracle_id = fpi.oracle_id
AND fpi.install_group_num IN (0, 1) --MSOB no more supported
AND UPPER(adp.product_abbreviation)
= UPPER(SUBSTR( fap.basepath
,1
,INSTR(fap.basepath,'_TOP') - 1
)
)
AND fou_apps.install_group_num = 1 -- fpi.install_group_num (5330846)
AND fou_apps.read_only_flag = 'U'
;
SELECT user_name
INTO p_user_name
FROM fnd_user
WHERE user_id = p_user_id;