APPS.MSC_POST_PRO dependencies on FND_ORACLE_USERID

Line 179: FROM FND_ORACLE_USERID a,

175: msc_util.msc_log('Begin Post Processing');
176: l_retval := FND_INSTALLATION.GET_APP_INFO('FND', dummy1, dummy2, l_applsys_schema);
177: SELECT a.oracle_username
178: INTO l_msc_schema
179: FROM FND_ORACLE_USERID a,
180: FND_PRODUCT_INSTALLATIONS b
181: WHERE a.oracle_id = b.oracle_id
182: AND b.application_id = 724;
183:

Line 1155: FROM FND_ORACLE_USERID a,

1151:
1152: l_retval := FND_INSTALLATION.GET_APP_INFO('FND', dummy1, dummy2, l_applsys_schema);
1153: SELECT a.oracle_username
1154: INTO l_msc_schema
1155: FROM FND_ORACLE_USERID a,
1156: FND_PRODUCT_INSTALLATIONS b
1157: WHERE a.oracle_id = b.oracle_id
1158: AND b.application_id = 724;
1159:

Line 3695: FROM FND_ORACLE_USERID a,

3691:
3692: l_retval := FND_INSTALLATION.GET_APP_INFO('FND', dummy1, dummy2, l_applsys_schema);
3693: SELECT a.oracle_username
3694: INTO l_msc_schema
3695: FROM FND_ORACLE_USERID a,
3696: FND_PRODUCT_INSTALLATIONS b
3697: WHERE a.oracle_id = b.oracle_id
3698: AND b.application_id = 724;
3699:

Line 4203: FROM fnd_oracle_userid a,

4199: FND_GLOBAL.USER_ID
4200: INTO l_msc_schema,
4201: l_sysdate,
4202: l_user_id
4203: FROM fnd_oracle_userid a,
4204: fnd_product_installations b
4205: WHERE a.oracle_id = b.oracle_id
4206: AND b.application_id = 724;
4207:

Line 6518: FROM FND_ORACLE_USERID a,

6514: msc_util.msc_log('completely purging temp tables');
6515: --bug3545959 start
6516: SELECT a.oracle_username
6517: INTO l_mrp_schema
6518: FROM FND_ORACLE_USERID a,
6519: FND_PRODUCT_INSTALLATIONS b
6520: WHERE a.oracle_id = b.oracle_id
6521: AND b.application_id = 704;
6522:

Line 6531: FROM FND_ORACLE_USERID a,

6527:
6528: --bug3940999
6529: SELECT a.oracle_username
6530: INTO l_msc_schema
6531: FROM FND_ORACLE_USERID a,
6532: FND_PRODUCT_INSTALLATIONS b
6533: WHERE a.oracle_id = b.oracle_id
6534: AND b.application_id = 724;
6535:

Line 8873: FROM FND_ORACLE_USERID a,

8869: msc_util.msc_log('Gather_Summ_Plan_Stats: ' || 'Gather Table Stats for S/D Tables');
8870:
8871: SELECT a.oracle_username
8872: INTO l_msc_schema
8873: FROM FND_ORACLE_USERID a,
8874: FND_PRODUCT_INSTALLATIONS b
8875: WHERE a.oracle_id = b.oracle_id
8876: AND b.application_id = 724;
8877: