[Home] [Help]
View: ARBV_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'
, /* IDS */ MCCD.LINE_ID
, MCCD.SET_OF_BOOKS_ID /* WHO COLUMNS */
FROM AR_MC_DISTRIBUTIONS_ALL MCCD
, AR_MC_CASH_RECEIPT_HIST MCRH
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 WITH READ ONLY
Columns
Name |
FUNCTIONAL_DEBIT_AMOUNT |
FUNCTIONAL_CREDIT_AMOUNT |
"_LA:POSTED_FLAG" |
LINE_ID |
SET_OF_BOOKS_ID |