[Home] [Help]
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
Name |
ROW_ID |
NAME |
RECEIPT_CLASS_ID |
RECEIPT_METHOD_ID |
START_DATE |
END_DATE |
REMIT_METHOD_CODE |
CREATION_STATUS |
CLASS_NAME |