DBA Data[Home] [Help]

APPS.FND_CONCURRENT dependencies on FND_LOOKUP_VALUES

Line 1800: FND_LOOKUP_VALUES_VL flv

1796: fcp.SERVICE_PARAMETERS c_parameters
1797: from FND_CONCURRENT_QUEUES fcq,
1798: FND_CONCURRENT_PROCESSES fcp,
1799: FND_APPLICATION fa,
1800: FND_LOOKUP_VALUES_VL flv
1801: where
1802: fcp.QUEUE_APPLICATION_ID = fcq.APPLICATION_ID
1803: and fcp.CONCURRENT_QUEUE_ID = fcq.CONCURRENT_QUEUE_ID
1804: and fcq.APPLICATION_ID = fa.APPLICATION_ID

Line 1813: from fnd_lookup_values flv2

1809: and ((proc_state is not null)
1810: or (fcp.PROCESS_STATUS_CODE not in ('S', 'K', 'U')))
1811: and exists
1812: (select 1
1813: from fnd_lookup_values flv2
1814: where flv2.LOOKUP_TYPE = ltype
1815: and flv2.LOOKUP_CODE = fcp.PROCESS_STATUS_CODE
1816: and upper(flv2.meaning) =
1817: upper(nvl(proc_state,flv2.meaning)));