VIEW: APPS.CE_RECEIPT_METHODS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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