View: CE_RECEIPT_METHODS_V

Product:	CE - Cash Management
Description:	Payment Methods available in CE
Implementation/DBA Data:	APPS.CE_RECEIPT_METHODS_V

View Text

SELECT RM.ROWID ROW_ID
, RM.NAME NAME
, RM.RECEIPT_CLASS_ID RECEIPT_CLASS_ID
, RM.RECEIPT_METHOD_ID RECEIPT_METHOD_ID
, RM.START_DATE START_DATE
, RM.END_DATE END_DATE
, RC.REMIT_METHOD_CODE REMIT_METHOD_CODE
, RC.CREATION_STATUS CREATION_STATUS
, RC.NAME CLASS_NAME
FROM AR_RECEIPT_METHODS RM
, AR_RECEIPT_CLASSES RC
WHERE RM.RECEIPT_CLASS_ID = RC.RECEIPT_CLASS_ID
AND RC.CREATION_STATUS IN ('CLEARED'
, 'REMITTED'
, 'CONFIRMED')
AND RC.CREATION_METHOD_CODE IN ('MANUAL'
, 'AUTOMATIC')

Columns