DBA Data[Home] [Help]

APPS_NE.OKC_QUEUE_RULE_PVT dependencies on FND_ORACLE_USERID

Line 15: SELECT oracle_username INTO l_owner FROM system.FND_ORACLE_USERID WHERE read_only_flag = 'E';

11: l_okc_owner VARCHAR2(30);
12:
13: BEGIN
14:
15: SELECT oracle_username INTO l_owner FROM system.FND_ORACLE_USERID WHERE read_only_flag = 'E';
16:
17: /*modified for bug 12679276*/
18: EXECUTE IMMEDIATE 'select fou.oracle_username
19: from '||l_owner||'.FND_PRODUCT_INSTALLATIONS# FPI,

Line 20: '||l_owner||'.FND_ORACLE_USERID# FOU,

16:
17: /*modified for bug 12679276*/
18: EXECUTE IMMEDIATE 'select fou.oracle_username
19: from '||l_owner||'.FND_PRODUCT_INSTALLATIONS# FPI,
20: '||l_owner||'.FND_ORACLE_USERID# FOU,
21: '||l_owner||'.FND_APPLICATION# FA
22: where fpi.application_id = fa.application_id
23: and fpi.oracle_id = fou.oracle_id
24: and fa.application_short_name = ''OKC''' INTO l_okc_owner;