VIEW: APPS.AME_ATTRIBUTES_V

Source

View Text - Preformatted

SELECT ATR.ATTRIBUTE_ID ,ATR.NAME ,ATR.ATTRIBUTE_TYPE ,ATR.DESCRIPTION ,ATR.APPROVER_TYPE_ID ,ATR.ITEM_CLASS_ID ,ACA.APPLICATION_ID ,ACA.FND_APPLICATION_ID ,ACA.TRANSACTION_TYPE_ID ,ATU.QUERY_STRING ,ATU.IS_STATIC ,ATU.CREATED_BY ,ATU.CREATION_DATE ,ATU.VALUE_SET_ID ,ATU.OBJECT_VERSION_NUMBER FROM AME_ATTRIBUTES_VL ATR ,AME_ATTRIBUTE_USAGES ATU ,AME_CALLING_APPS ACA WHERE ATR.ATTRIBUTE_ID = ATU.ATTRIBUTE_ID AND ATU.APPLICATION_ID = ACA.APPLICATION_ID AND SYSDATE BETWEEN ATR.START_DATE AND NVL(ATR.END_DATE - (1/86400), SYSDATE) AND SYSDATE BETWEEN ATU.START_DATE AND NVL(ATU.END_DATE - (1/86400), SYSDATE) AND SYSDATE BETWEEN ACA.START_DATE AND NVL(ACA.END_DATE - (1/86400), SYSDATE)

View Text - HTML Formatted

SELECT ATR.ATTRIBUTE_ID
, ATR.NAME
, ATR.ATTRIBUTE_TYPE
, ATR.DESCRIPTION
, ATR.APPROVER_TYPE_ID
, ATR.ITEM_CLASS_ID
, ACA.APPLICATION_ID
, ACA.FND_APPLICATION_ID
, ACA.TRANSACTION_TYPE_ID
, ATU.QUERY_STRING
, ATU.IS_STATIC
, ATU.CREATED_BY
, ATU.CREATION_DATE
, ATU.VALUE_SET_ID
, ATU.OBJECT_VERSION_NUMBER
FROM AME_ATTRIBUTES_VL ATR
, AME_ATTRIBUTE_USAGES ATU
, AME_CALLING_APPS ACA
WHERE ATR.ATTRIBUTE_ID = ATU.ATTRIBUTE_ID
AND ATU.APPLICATION_ID = ACA.APPLICATION_ID
AND SYSDATE BETWEEN ATR.START_DATE
AND NVL(ATR.END_DATE - (1/86400)
, SYSDATE)
AND SYSDATE BETWEEN ATU.START_DATE
AND NVL(ATU.END_DATE - (1/86400)
, SYSDATE)
AND SYSDATE BETWEEN ACA.START_DATE
AND NVL(ACA.END_DATE - (1/86400)
, SYSDATE)