SELECT lookup_code agent_id , meaning agent_name from fnd_lookups WHERE lookup_type = 'BIX_DM_ALL_LOOKUP' union select to_char(resource_id) agent_id , source_name agent_name from jtf_rs_resource_extns order by agent_name
SELECT LOOKUP_CODE AGENT_ID
, MEANING AGENT_NAME
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'BIX_DM_ALL_LOOKUP' UNION SELECT TO_CHAR(RESOURCE_ID) AGENT_ID
, SOURCE_NAME AGENT_NAME
FROM JTF_RS_RESOURCE_EXTNS ORDER BY AGENT_NAME
|
|
|