DBA Data[Home] [Help]

APPS.BSC_MO_UI_PKG dependencies on FND_APPLICATION

Line 1311: FROM FND_CONCURRENT_REQUESTS R, FND_CONCURRENT_PROGRAMS_VL P, FND_APPLICATION A

1307: DELETE BSC_TMP_OPT_UI_KPIS
1308: WHERE PROCESS_ID > 0
1309: AND TO_CHAR(PROCESS_ID) NOT IN (
1310: SELECT /*+ INDEX(R FND_CONCURRENT_REQUESTS_N6)*/ R.ARGUMENT2
1311: FROM FND_CONCURRENT_REQUESTS R, FND_CONCURRENT_PROGRAMS_VL P, FND_APPLICATION A
1312: WHERE A.APPLICATION_SHORT_NAME = BSC_MO_HELPER_PKG.getBSCSchema
1313: AND A.APPLICATION_ID = P.APPLICATION_ID
1314: AND P.APPLICATION_ID = R.PROGRAM_APPLICATION_ID
1315: AND P.CONCURRENT_PROGRAM_ID = R.CONCURRENT_PROGRAM_ID