VIEW: APPS.ARBV_ADJ_DISTS_ALT_CRNCY

Source

View Text - Preformatted

SELECT /* UNIQUE ATTRIBUTES */ /* REGULAR ATTRIBUTES */ DECODE(SIGN(ADJ.ACCTD_AMOUNT),-1,ABS(ADJ.ACCTD_AMOUNT),NULL) , DECODE(SIGN(ADJ.ACCTD_AMOUNT),1,ADJ.ACCTD_AMOUNT,NULL) , '_LA:DECODE(ADJ.POSTING_CONTROL_ID,-3,''N'',''Y''):AR_LOOKUPS:YES/NO:MEANING' , /* IDS */ ADJ.ADJUSTMENT_ID , ADJ.SET_OF_BOOKS_ID /* WHO COLUMNS */ FROM AR_MC_ADJUSTMENTS ADJ WITH READ ONLY

View Text - HTML Formatted

SELECT /* UNIQUE ATTRIBUTES */ /* REGULAR ATTRIBUTES */ DECODE(SIGN(ADJ.ACCTD_AMOUNT)
, -1
, ABS(ADJ.ACCTD_AMOUNT)
, NULL)
, DECODE(SIGN(ADJ.ACCTD_AMOUNT)
, 1
, ADJ.ACCTD_AMOUNT
, NULL)
, '_LA:DECODE(ADJ.POSTING_CONTROL_ID
, -3
, ''N''
, ''Y''):AR_LOOKUPS:YES/NO:MEANING'
, /* IDS */ ADJ.ADJUSTMENT_ID
, ADJ.SET_OF_BOOKS_ID /* WHO COLUMNS */
FROM AR_MC_ADJUSTMENTS ADJ WITH READ ONLY