View: CE_RECEIVABLE_ACTIVITIES_V

Product:	CE - Cash Management
Description:	- Retrofitted
Implementation/DBA Data:	APPS.CE_RECEIVABLE_ACTIVITIES_V

View Text

SELECT ART.RECEIVABLES_TRX_ID RECEIVABLES_TRX_ID
, ART.NAME NAME
, ART.DESCRIPTION DESCRIPTION
, ART.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, ART.ASSET_TAX_CODE
, ART.ORG_ID FROM AR_RECEIVABLES_TRX ART
WHERE ART.TYPE IN ( 'MISCCASH'
, 'BANK_ERROR' ) AND NVL( ART.STATUS
, 'A' ) = 'A' AND SYSDATE >= NVL( ART.START_DATE_ACTIVE
, SYSDATE ) AND SYSDATE <= NVL( ART.END_DATE_ACTIVE
, SYSDATE )
AND MO_GLOBAL.CHECK_ACCESS(ART.ORG_ID) = 'Y'

Columns