View: ARFV_CASH_DISTS_ALT_CRNCY

Product:	AR - Receivables
Description:	- Retrofitted
Implementation/DBA Data:	APPS.ARFV_CASH_DISTS_ALT_CRNCY

View Text

SELECT /* UNIQUE ATTRIBUTES */ /* REGULAR ATTRIBUTES */ MCCD.ACCTD_AMOUNT_DR
, MCCD.ACCTD_AMOUNT_CR
, '_LA:DECODE(MCRH.POSTING_CONTROL_ID
, -3
, ''N''
, ''Y''):AR_LOOKUPS:YES/NO:MEANING'
, /* RESOLVED FK RESOLUTIONS */ SOB.NAME
, /* IDS */ MCCD.LINE_ID
, MCCD.SET_OF_BOOKS_ID /* WHO COLUMNS */
FROM AR_MC_DISTRIBUTIONS_ALL MCCD
, AR_MC_CASH_RECEIPT_HIST MCRH
, GL_SETS_OF_BOOKS SOB
WHERE MCCD.SOURCE_ID = MCRH.CASH_RECEIPT_HISTORY_ID AND MCCD.SOURCE_TABLE = 'CRH'
AND MCCD.SET_OF_BOOKS_ID = MCRH.SET_OF_BOOKS_ID
AND MCCD.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID WITH READ ONLY

Columns