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.PA_INVOICE_SCHEDULES_LOV_V

Source

View Text - Preformatted


SELECT irs.ind_rate_sch_id , irs.ind_rate_sch_name FROM pa_ind_rate_schedules irs WHERE irs.project_id is null AND trunc(sysdate) between trunc(irs.start_date_active ) AND nvl (irs.end_date_active,trunc(sysdate)) order by 1

View Text - HTML Formatted

SELECT IRS.IND_RATE_SCH_ID
, IRS.IND_RATE_SCH_NAME
FROM PA_IND_RATE_SCHEDULES IRS
WHERE IRS.PROJECT_ID IS NULL
AND TRUNC(SYSDATE) BETWEEN TRUNC(IRS.START_DATE_ACTIVE )
AND NVL (IRS.END_DATE_ACTIVE
, TRUNC(SYSDATE)) ORDER BY 1