DBA Data[Home] [Help]

APPS.XLA_CMP_COMMON_PKG dependencies on FND_ORACLE_USERID

Line 18: | will only be one row in fnd_oracle_userid to retrieve the schema|

14: | HISTORY |
15: | 30-JAN-04 A.Quaglia Created |
16: | 15-MAY-2006 Jorge Larre Fix for bug 5330846. This is a temporary |
17: | fix until we get a confirmation from the ATG team that there |
18: | will only be one row in fnd_oracle_userid to retrieve the schema|
19: | name with read_only_flag = 'U'. In this temporary fix we assume |
20: | that the install_group_num is 1 (this is correct in the internal|
21: | databases). |
22: | |

Line 142: ,fnd_oracle_userid fou

138: ,p_application_info.apps_account
139: FROM fnd_application fap
140: ,fnd_application_vl fav
141: ,fnd_product_installations fpi
142: ,fnd_oracle_userid fou
143: ,ad_pm_product_info adp
144: ,fnd_oracle_userid fou_apps
145: WHERE fap.application_id = p_application_id
146: AND fav.application_id = fap.application_id

Line 144: ,fnd_oracle_userid fou_apps

140: ,fnd_application_vl fav
141: ,fnd_product_installations fpi
142: ,fnd_oracle_userid fou
143: ,ad_pm_product_info adp
144: ,fnd_oracle_userid fou_apps
145: WHERE fap.application_id = p_application_id
146: AND fav.application_id = fap.application_id
147: AND fpi.application_id = fap.application_id
148: AND fou.oracle_id = fpi.oracle_id