DBA Data[Home] [Help]

VIEW: APPS.BIX_AGENT_V

Source

View Text - Preformatted

SELECT to_char(jre.resource_id) , ppf.full_name , jre.START_DATE_ACTIVE , jre.CATEGORY FROM jtf_rs_resource_extns jre, per_people_f ppf WHERE ppf.person_id = jre.source_id order by 2
View Text - HTML Formatted

SELECT TO_CHAR(JRE.RESOURCE_ID)
, PPF.FULL_NAME
, JRE.START_DATE_ACTIVE
, JRE.CATEGORY
FROM JTF_RS_RESOURCE_EXTNS JRE
, PER_PEOPLE_F PPF
WHERE PPF.PERSON_ID = JRE.SOURCE_ID ORDER BY 2