DBA Data[Home] [Help]

APPS.MSC_MANAGE_PLAN_PARTITIONS dependencies on FND_PRODUCT_INSTALLATIONS

Line 145: FROM FND_ORACLE_USERID a, FND_PRODUCT_INSTALLATIONS b

141: x_msg_data OUT NOCOPY VARCHAR2) IS
142:
143: CURSOR C_SCHEMA IS
144: SELECT a.oracle_username
145: FROM FND_ORACLE_USERID a, FND_PRODUCT_INSTALLATIONS b
146: WHERE a.oracle_id = b.oracle_id
147: AND b.application_id = 724;
148:
149: l_partition_name VARCHAR2(100);

Line 231: FROM FND_ORACLE_USERID a, FND_PRODUCT_INSTALLATIONS b

227: IS
228:
229: CURSOR C_SCHEMA IS
230: SELECT a.oracle_username
231: FROM FND_ORACLE_USERID a, FND_PRODUCT_INSTALLATIONS b
232: WHERE a.oracle_id = b.oracle_id
233: AND b.application_id = 724;
234:
235:

Line 392: FROM FND_ORACLE_USERID a, FND_PRODUCT_INSTALLATIONS b

388: IS
389:
390: CURSOR C_SCHEMA IS
391: SELECT a.oracle_username
392: FROM FND_ORACLE_USERID a, FND_PRODUCT_INSTALLATIONS b
393: WHERE a.oracle_id = b.oracle_id
394: AND b.application_id = 724;
395:
396: l_dummy_partition_name VARCHAR2(100);

Line 1410: FROM FND_ORACLE_USERID a, FND_PRODUCT_INSTALLATIONS b

1406:
1407:
1408: Cursor msc_schema IS
1409: SELECT a.oracle_username
1410: FROM FND_ORACLE_USERID a, FND_PRODUCT_INSTALLATIONS b
1411: WHERE a.oracle_id = b.oracle_id
1412: AND b.application_id= 724;
1413:
1414: /* --bug 3274373: Refresh Materialized view in ATP post plan processing.