eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.POA_BIS_SAVINGS_BUYER_LOV_V

Source

View Text - Preformatted


SELECT hr.person_id, hr.full_name NAME from po_agents poa, per_all_people_f hr WHERE poa.agent_id = hr.person_id and trunc(sysdate) between hr.effective_start_date and hr.effective_end_date

View Text - HTML Formatted

SELECT HR.PERSON_ID
, HR.FULL_NAME NAME
FROM PO_AGENTS POA
, PER_ALL_PEOPLE_F HR
WHERE POA.AGENT_ID = HR.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN HR.EFFECTIVE_START_DATE
AND HR.EFFECTIVE_END_DATE