SELECT 1 sort_col, lookup_code resource_id, meaning resource_name FROM fnd_lookups WHERE lookup_type = 'BIX_DM_ALL_LOOKUP' UNION SELECT 2 sort_col, TO_CHAR(resource_id) resource_id, resource_name FROM jtf_rs_resource_extns_vl r WHERE EXISTS ( SELECT 'DUMMY' FROM jtf_rs_resource_values resource_values WHERE r.resource_id = resource_values.resource_id AND resource_values.value = 'IEM_DEFAULT_VALUE' )
SELECT 1 SORT_COL
, LOOKUP_CODE RESOURCE_ID
, MEANING RESOURCE_NAME
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'BIX_DM_ALL_LOOKUP' UNION SELECT 2 SORT_COL
, TO_CHAR(RESOURCE_ID) RESOURCE_ID
, RESOURCE_NAME
FROM JTF_RS_RESOURCE_EXTNS_VL R
WHERE EXISTS ( SELECT 'DUMMY'
FROM JTF_RS_RESOURCE_VALUES RESOURCE_VALUES
WHERE R.RESOURCE_ID = RESOURCE_VALUES.RESOURCE_ID
AND RESOURCE_VALUES.VALUE = 'IEM_DEFAULT_VALUE' )
|
|
|