DBA Data[Home] [Help]

APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on FND_CONCURRENT_REQUESTS

Line 1295: FROM Fnd_Concurrent_Requests FCR

1291: WHERE
1292: customer_trx_id = cp_customer_trx_id ;
1293: */
1294: SELECT '1'
1295: FROM Fnd_Concurrent_Requests FCR
1296: WHERE FCR.argument1 = to_char(cp_customer_trx_id)
1297: and fcr.status_code<> 'C'
1298: and fcr.phase_code<>'C'
1299: AND fcr.request_id IN (Select nvl(Max(Request_ID),-1)

Line 1302: Fnd_Concurrent_Requests FCR

1298: and fcr.phase_code<>'C'
1299: AND fcr.request_id IN (Select nvl(Max(Request_ID),-1)
1300: From Fnd_Concurrent_Programs FCP,
1301: Fnd_Application FA ,
1302: Fnd_Concurrent_Requests FCR
1303: Where FCR.Program_Application_ID = FA.Application_ID
1304: AND FCR.Concurrent_Program_ID = FCP.Concurrent_Program_ID
1305: AND FA.Application_ID = FCP.Application_ID
1306: AND Concurrent_Program_Name = 'JAILINEGL'