[Home] [Help]
View: ARFV_ADJ_DISTS_ALT_CRNCY
View Text
SELECT /* UNIQUE ATTRIBUTES */ /* REGULAR ATTRIBUTES */ ARD.ACCTD_AMOUNT_DR
, ARD.ACCTD_AMOUNT_CR
, '_LA:DECODE(ADJ.POSTING_CONTROL_ID
, -3
, ''N''
, ''Y''):AR_LOOKUPS:YES/NO:MEANING'
, /* IDS */ MCADJ.ADJUSTMENT_ID
, MCADJ.SET_OF_BOOKS_ID /* WHO COLUMNS */
FROM AR_MC_ADJUSTMENTS MCADJ
, AR_ADJUSTMENTS_ALL ADJ
, AR_DISTRIBUTIONS_ALL ARD
WHERE MCADJ.ADJUSTMENT_ID = ADJ.ADJUSTMENT_ID
AND ARD.SOURCE_ID = ADJ.ADJUSTMENT_ID
AND ARD.SOURCE_TABLE = 'ADJ'
AND ARD.SOURCE_TYPE = 'ADJ' WITH READ ONLY
Columns
| Name |
| "FUNCTIONAL_DEBIT_AMOUNT" |
| "FUNCTIONAL_CREDIT_AMOUNT" |
| "_LA:POSTED_FLAG" |
| "ADJUSTMENT_ID" |
| "SET_OF_BOOKS_ID" |
APPS.ARFV_ADJ_DISTS_ALT_CRNCY