View: AR_RECEIPT_METHOD_NAME_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.AR_RECEIPT_METHOD_NAME_V

View Text

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))

Columns