DBA Data[Home] [Help]

APPS.MSC_POST_PRO dependencies on FND_PRODUCT_INSTALLATIONS

Line 180: FND_PRODUCT_INSTALLATIONS b

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:
184: msc_util.msc_log('l_applsys_schema ;= ' || l_applsys_schema);

Line 1156: FND_PRODUCT_INSTALLATIONS b

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:
1160: FOR i in 1..atp_summ_tab.count LOOP

Line 3696: FND_PRODUCT_INSTALLATIONS b

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:
3700:

Line 4204: fnd_product_installations b

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:
4208: FOR i in 1..atp_summ_tab.count LOOP

Line 6519: FND_PRODUCT_INSTALLATIONS b

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:
6523: msc_util.msc_log('l_mrp_schema: ' || l_mrp_schema );

Line 6532: FND_PRODUCT_INSTALLATIONS b

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:
6536: msc_util.msc_log('l_msc_schema: ' || l_msc_schema );

Line 8874: FND_PRODUCT_INSTALLATIONS b

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:
8878: IF p_share_partition = 'Y' THEN