DBA Data[Home] [Help]

APPS.FND_CONCURRENT dependencies on FND_LOOKUP_VALUES

Line 1691: FND_LOOKUP_VALUES_VL flv

1687: fcp.SERVICE_PARAMETERS c_parameters
1688: from FND_CONCURRENT_QUEUES fcq,
1689: FND_CONCURRENT_PROCESSES fcp,
1690: FND_APPLICATION fa,
1691: FND_LOOKUP_VALUES_VL flv
1692: where
1693: fcp.QUEUE_APPLICATION_ID = fcq.APPLICATION_ID
1694: and fcp.CONCURRENT_QUEUE_ID = fcq.CONCURRENT_QUEUE_ID
1695: and fcq.APPLICATION_ID = fa.APPLICATION_ID

Line 1704: from fnd_lookup_values flv2

1700: and ((proc_state is not null)
1701: or (fcp.PROCESS_STATUS_CODE not in ('S', 'K', 'U')))
1702: and exists
1703: (select 1
1704: from fnd_lookup_values flv2
1705: where flv2.LOOKUP_TYPE = ltype
1706: and flv2.LOOKUP_CODE = fcp.PROCESS_STATUS_CODE
1707: and upper(flv2.meaning) =
1708: upper(nvl(proc_state,flv2.meaning)));