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

Source

View Text - Preformatted


SELECT RUL.RULE_ID ,CNU.CONDITION_ID ,CNU.OBJECT_VERSION_NUMBER FROM AME_RULES RUL ,AME_CONDITION_USAGES CNU WHERE RUL.RULE_ID = CNU.RULE_ID AND((SYSDATE BETWEEN RUL.START_DATE AND NVL(RUL.END_DATE - (1/86400), SYSDATE)) OR (SYSDATE < RUL.START_DATE AND RUL.START_DATE < NVL(RUL.END_DATE, RUL.START_DATE + (1/86400)))) AND((SYSDATE BETWEEN CNU.START_DATE AND NVL(CNU.END_DATE - (1/86400), SYSDATE)) OR (SYSDATE < CNU.START_DATE AND CNU.START_DATE < NVL(CNU.END_DATE, CNU.START_DATE + (1/86400))))

View Text - HTML Formatted

SELECT RUL.RULE_ID
, CNU.CONDITION_ID
, CNU.OBJECT_VERSION_NUMBER
FROM AME_RULES RUL
, AME_CONDITION_USAGES CNU
WHERE RUL.RULE_ID = CNU.RULE_ID AND((SYSDATE BETWEEN RUL.START_DATE
AND NVL(RUL.END_DATE - (1/86400)
, SYSDATE)) OR (SYSDATE < RUL.START_DATE
AND RUL.START_DATE < NVL(RUL.END_DATE
, RUL.START_DATE + (1/86400)))) AND((SYSDATE BETWEEN CNU.START_DATE
AND NVL(CNU.END_DATE - (1/86400)
, SYSDATE)) OR (SYSDATE < CNU.START_DATE
AND CNU.START_DATE < NVL(CNU.END_DATE
, CNU.START_DATE + (1/86400))))