[Home] [Help]
View: 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
Name |
RECEIVABLES_TRX_ID |
NAME |
DESCRIPTION |
SET_OF_BOOKS_ID |
ASSET_TAX_CODE |
ORG_ID |