VIEW: APPS.CE_RECEIVABLE_ACTIVITIES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'