VIEW: APPS.AME_CONDITIONS_V

Source

View Text - Preformatted

SELECT CON.CONDITION_ID ,CON.CONDITION_KEY ,ATR.NAME ,CON.ATTRIBUTE_ID ,CON.CREATED_BY ,CON.CREATION_DATE ,CON.OBJECT_VERSION_NUMBER FROM AME_CONDITIONS CON ,AME_ATTRIBUTES ATR WHERE CON.ATTRIBUTE_ID = ATR.ATTRIBUTE_ID AND SYSDATE BETWEEN CON.START_DATE AND NVL(CON.END_DATE - (1/86400), SYSDATE) AND SYSDATE BETWEEN ATR.START_DATE AND NVL(ATR.END_DATE - (1/86400), SYSDATE)

View Text - HTML Formatted

SELECT CON.CONDITION_ID
, CON.CONDITION_KEY
, ATR.NAME
, CON.ATTRIBUTE_ID
, CON.CREATED_BY
, CON.CREATION_DATE
, CON.OBJECT_VERSION_NUMBER
FROM AME_CONDITIONS CON
, AME_ATTRIBUTES ATR
WHERE CON.ATTRIBUTE_ID = ATR.ATTRIBUTE_ID
AND SYSDATE BETWEEN CON.START_DATE
AND NVL(CON.END_DATE - (1/86400)
, SYSDATE)
AND SYSDATE BETWEEN ATR.START_DATE
AND NVL(ATR.END_DATE - (1/86400)
, SYSDATE)