[Home] [Help]
View: ARBV_FREIGHT_DISTS_ALT_CRNCY
View Text
SELECT /* UNIQUE ATTRIBUTES */ /* REGULAR ATTRIBUTES */ DECODE(SIGN(MLGD.ACCTD_AMOUNT)
, -1
, ABS(MLGD.ACCTD_AMOUNT)
, NULL)
, DECODE(SIGN(MLGD.ACCTD_AMOUNT)
, 1
, MLGD.ACCTD_AMOUNT
, NULL)
, '_LA:DECODE(MLGD.POSTING_CONTROL_ID
, -3
, ''N''
, ''Y''):AR_LOOKUPS:YES/NO:MEANING'
, /* IDS */ MLGD.CUST_TRX_LINE_GL_DIST_ID
, MLGD.SET_OF_BOOKS_ID
, MLGD.CUSTOMER_TRX_ID /* WHO COLUMNS */
FROM RA_MC_TRX_LINE_GL_DIST MLGD
WHERE ACCOUNT_CLASS = 'FREIGHT' WITH READ ONLY
Columns
Name |
FUNCTIONAL_DEBIT_AMOUNT |
FUNCTIONAL_CREDIT_AMOUNT |
"_LA:POSTED_FLAG" |
CUST_TRX_LINE_GL_DIST_ID |
SET_OF_BOOKS_ID |
CUSTOMER_TRX_ID |