VIEW: APPS.AME_RULES_V

Source

View Text - Preformatted

SELECT RUL.RULE_ID ,RUL.RULE_KEY ,RUL.RULE_TYPE ,RUL.DESCRIPTION ,RUL.ITEM_CLASS_ID ,RLU.ITEM_ID ,ACA.FND_APPLICATION_ID ,ACA.TRANSACTION_TYPE_ID ,RLU.CREATED_BY ,RLU.CREATION_DATE ,RLU.START_DATE ,RLU.END_DATE ,RLU.PRIORITY ,RLU.APPROVER_CATEGORY ,RLU.OBJECT_VERSION_NUMBER FROM AME_RULES_VL RUL ,AME_RULE_USAGES RLU ,AME_CALLING_APPS ACA WHERE RUL.RULE_ID = RLU.RULE_ID AND RLU.ITEM_ID = ACA.APPLICATION_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 RLU.START_DATE AND NVL(RLU.END_DATE - (1/86400), SYSDATE)) OR (SYSDATE < RLU.START_DATE AND RLU.START_DATE < NVL(RLU.END_DATE, RLU.START_DATE + (1/86400)))) AND SYSDATE BETWEEN ACA.START_DATE AND NVL(ACA.END_DATE - (1/86400), SYSDATE)

View Text - HTML Formatted

SELECT RUL.RULE_ID
, RUL.RULE_KEY
, RUL.RULE_TYPE
, RUL.DESCRIPTION
, RUL.ITEM_CLASS_ID
, RLU.ITEM_ID
, ACA.FND_APPLICATION_ID
, ACA.TRANSACTION_TYPE_ID
, RLU.CREATED_BY
, RLU.CREATION_DATE
, RLU.START_DATE
, RLU.END_DATE
, RLU.PRIORITY
, RLU.APPROVER_CATEGORY
, RLU.OBJECT_VERSION_NUMBER
FROM AME_RULES_VL RUL
, AME_RULE_USAGES RLU
, AME_CALLING_APPS ACA
WHERE RUL.RULE_ID = RLU.RULE_ID
AND RLU.ITEM_ID = ACA.APPLICATION_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 RLU.START_DATE
AND NVL(RLU.END_DATE - (1/86400)
, SYSDATE)) OR (SYSDATE < RLU.START_DATE
AND RLU.START_DATE < NVL(RLU.END_DATE
, RLU.START_DATE + (1/86400))))
AND SYSDATE BETWEEN ACA.START_DATE
AND NVL(ACA.END_DATE - (1/86400)
, SYSDATE)