VIEW: APPS.ARFV_UNREC_DISTS_ALT_CRNCY

Source

View Text - Preformatted

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' ,/*RESOLVED FK RESOLUTIONS */ SOB.NAME , CT.TRX_NUMBER , /* 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, GL_SETS_OF_BOOKS SOB, RA_CUSTOMER_TRX_ALL CT WHERE MLGD.ACCOUNT_CLASS = 'UNBILL' AND MLGD.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID AND MLGD.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID WITH READ ONLY

View Text - HTML Formatted

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'
, /*RESOLVED FK RESOLUTIONS */ SOB.NAME
, CT.TRX_NUMBER
, /* 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
, GL_SETS_OF_BOOKS SOB
, RA_CUSTOMER_TRX_ALL CT
WHERE MLGD.ACCOUNT_CLASS = 'UNBILL'
AND MLGD.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
AND MLGD.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID WITH READ ONLY