VIEW: APPS.AR_RECEIPT_METHOD_NAME_V

Source

View Text - Preformatted

SELECT RM.RECEIPT_METHOD_ID , RM.NAME , RM.MERCHANT_ID , RC.NAME CLASS FROM AR_RECEIPT_METHODS RM , AR_RECEIPT_CLASSES RC WHERE RM.RECEIPT_CLASS_ID = RC.RECEIPT_CLASS_ID AND RM.PAYMENT_TYPE_CODE = 'CREDIT_CARD' AND TRUNC(SYSDATE) BETWEEN RM.START_DATE AND NVL(RM.END_DATE,TRUNC(SYSDATE))

View Text - HTML Formatted

SELECT RM.RECEIPT_METHOD_ID
, RM.NAME
, RM.MERCHANT_ID
, RC.NAME CLASS
FROM AR_RECEIPT_METHODS RM
, AR_RECEIPT_CLASSES RC
WHERE RM.RECEIPT_CLASS_ID = RC.RECEIPT_CLASS_ID
AND RM.PAYMENT_TYPE_CODE = 'CREDIT_CARD'
AND TRUNC(SYSDATE) BETWEEN RM.START_DATE
AND NVL(RM.END_DATE
, TRUNC(SYSDATE))