eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.ARFV_APP_DISTS_ALT_CRNCY

Source

View Text - Preformatted


SELECT /* APPLICATION DISTRIBUTIONS */ /* UNIQUE ATTRIBUTES */ /* REGULAR ATTRIBUTES */ DECODE(MCRA.STATUS, 'APP', DECODE(SIGN(MCRA.ACCTD_AMOUNT_APPLIED_TO),-1, ABS(MCRA.ACCTD_AMOUNT_APPLIED_TO),NULL), DECODE(SIGN(MCRA.ACCTD_AMOUNT_APPLIED_FROM),-1, ABS(MCRA.ACCTD_AMOUNT_APPLIED_FROM),NULL)) , DECODE(MCRA.STATUS, 'APP', DECODE(SIGN(MCRA.ACCTD_AMOUNT_APPLIED_TO),1, MCRA.ACCTD_AMOUNT_APPLIED_TO,NULL), DECODE(SIGN(MCRA.ACCTD_AMOUNT_APPLIED_FROM),1, MCRA.ACCTD_AMOUNT_APPLIED_FROM,NULL)) , '_LA:DECODE(MCRA.POSTING_CONTROL_ID,-3,''N'',''Y''):AR_LOOKUPS:YES/NO:MEANING' , /* RESOLVED FK RESOLUTIONS */ SOB.NAME , /* IDS */ MCRA.RECEIVABLE_APPLICATION_ID , '_LA:DECODE(MCRA.STATUS,''UNAPP'',''UNAPP'',''APP'',''REC'',''UNID'', 		''UNID'',''ACC'', ''ACC'',NULL):AR_LOOKUPS:ACCOUNT_TYPE:MEANING' , MCRA.SET_OF_BOOKS_ID /* WHO COLUMNS */ FROM AR_MC_RECEIVABLE_APPS MCRA, GL_SETS_OF_BOOKS SOB WHERE MCRA.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID UNION SELECT /* EARNED DISCOUNT DISTRIBUTIONS */ /* UNIQUE ATTRIBUTES */ /* REGULAR ATTRIBUTES */ DECODE(SIGN(MCRA.ACCTD_EARNED_DISCOUNT_TAKEN),-1, ABS(ACCTD_EARNED_DISCOUNT_TAKEN),NULL), DECODE(SIGN(MCRA.ACCTD_EARNED_DISCOUNT_TAKEN),1, ACCTD_EARNED_DISCOUNT_TAKEN,NULL), '_LA:DECODE(MCRA.POSTING_CONTROL_ID,-3,''N'',''Y''):AR_LOOKUPS:YES/NO:MEANING', /* RESOLVED FK RESOLUTIONS */ SOB.NAME, /* IDS */ MCRA.RECEIVABLE_APPLICATION_ID, '_LA:''EDISC'':AR_LOOKUPS:ACCOUNT_TYPE:MEANING', MCRA.SET_OF_BOOKS_ID /* WHO COLUMNS */ FROM AR_MC_RECEIVABLE_APPS MCRA, GL_SETS_OF_BOOKS SOB WHERE MCRA.ACCTD_EARNED_DISCOUNT_TAKEN IS NOT NULL AND MCRA.ACCTD_EARNED_DISCOUNT_TAKEN <> 0 AND MCRA.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID UNION SELECT /* UNEARNED DISCOUNT DISTRIBUTIONS */ /* UNIQUE ATTRIBUTES */ /* REGULAR ATTRIBUTES */ DECODE(SIGN(MCRA.ACCTD_UNEARNED_DISCOUNT_TAKEN),-1, ABS(ACCTD_UNEARNED_DISCOUNT_TAKEN),NULL), DECODE(SIGN(MCRA.ACCTD_UNEARNED_DISCOUNT_TAKEN),1, ACCTD_UNEARNED_DISCOUNT_TAKEN,NULL), '_LA:DECODE(MCRA.POSTING_CONTROL_ID,-3,''N'',  		''Y''):AR_LOOKUPS:YES/NO:MEANING', /* RESOLVED FK RESOLUTIONS */ SOB.NAME, /* IDS */ MCRA.RECEIVABLE_APPLICATION_ID, '_LA:''UEDISC'':AR_LOOKUPS:ACCOUNT_TYPE:MEANING', MCRA.SET_OF_BOOKS_ID /* WHO COLUMNS */ FROM AR_MC_RECEIVABLE_APPS MCRA, GL_SETS_OF_BOOKS SOB WHERE MCRA.ACCTD_UNEARNED_DISCOUNT_TAKEN IS NOT NULL AND MCRA.ACCTD_UNEARNED_DISCOUNT_TAKEN <> 0 AND MCRA.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID UNION SELECT /* EXCHANGE GAIN/LOSS DISTRIBUTIONS */ /* UNIQUE ATTRIBUTES */ /* REGULAR ATTRIBUTES */ DECODE(SIGN(MCRA.ACCTD_AMOUNT_APPLIED_FROM- MCRA.ACCTD_AMOUNT_APPLIED_TO),-1, ABS(MCRA.ACCTD_AMOUNT_APPLIED_FROM- MCRA.ACCTD_AMOUNT_APPLIED_TO), NULL), DECODE(SIGN(MCRA.ACCTD_AMOUNT_APPLIED_FROM- MCRA.ACCTD_AMOUNT_APPLIED_TO),1, (MCRA.ACCTD_AMOUNT_APPLIED_FROM- MCRA.ACCTD_AMOUNT_APPLIED_TO), NULL), '_LA:DECODE(MCRA.POSTING_CONTROL_ID,-3,''N'',  		''Y''):AR_LOOKUPS:YES/NO:MEANING', /* RESOLVED FK RESOLUTIONS */ SOB.NAME, /* IDS */ MCRA.RECEIVABLE_APPLICATION_ID, '_LA:DECODE(SIGN(MCRA.ACCTD_AMOUNT_APPLIED_FROM-  		MCRA.ACCTD_AMOUNT_APPLIED_TO),-1,''EXCH_LOSS'',1,  		''EXCH_GAIN''):AR_LOOKUPS:ACCOUNT_TYPE:MEANING', MCRA.SET_OF_BOOKS_ID /* WHO COLUMNS */ FROM AR_MC_RECEIVABLE_APPS MCRA, GL_SETS_OF_BOOKS SOB WHERE MCRA.ACCTD_AMOUNT_APPLIED_FROM <> MCRA.ACCTD_AMOUNT_APPLIED_TO AND MCRA.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID WITH READ ONLY

View Text - HTML Formatted

SELECT /* APPLICATION DISTRIBUTIONS */ /* UNIQUE ATTRIBUTES */ /* REGULAR ATTRIBUTES */ DECODE(MCRA.STATUS
, 'APP'
, DECODE(SIGN(MCRA.ACCTD_AMOUNT_APPLIED_TO)
, -1
, ABS(MCRA.ACCTD_AMOUNT_APPLIED_TO)
, NULL)
, DECODE(SIGN(MCRA.ACCTD_AMOUNT_APPLIED_FROM)
, -1
, ABS(MCRA.ACCTD_AMOUNT_APPLIED_FROM)
, NULL))
, DECODE(MCRA.STATUS
, 'APP'
, DECODE(SIGN(MCRA.ACCTD_AMOUNT_APPLIED_TO)
, 1
, MCRA.ACCTD_AMOUNT_APPLIED_TO
, NULL)
, DECODE(SIGN(MCRA.ACCTD_AMOUNT_APPLIED_FROM)
, 1
, MCRA.ACCTD_AMOUNT_APPLIED_FROM
, NULL))
, '_LA:DECODE(MCRA.POSTING_CONTROL_ID
, -3
, ''N''
, ''Y''):AR_LOOKUPS:YES/NO:MEANING'
, /* RESOLVED FK RESOLUTIONS */ SOB.NAME
, /* IDS */ MCRA.RECEIVABLE_APPLICATION_ID
, '_LA:DECODE(MCRA.STATUS
, ''UNAPP''
, ''UNAPP''
, ''APP''
, ''REC''
, ''UNID''
, ''UNID''
, ''ACC''
, ''ACC''
, NULL):AR_LOOKUPS:ACCOUNT_TYPE:MEANING'
, MCRA.SET_OF_BOOKS_ID /* WHO COLUMNS */
FROM AR_MC_RECEIVABLE_APPS MCRA
, GL_SETS_OF_BOOKS SOB
WHERE MCRA.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID UNION SELECT /* EARNED DISCOUNT DISTRIBUTIONS */ /* UNIQUE ATTRIBUTES */ /* REGULAR ATTRIBUTES */ DECODE(SIGN(MCRA.ACCTD_EARNED_DISCOUNT_TAKEN)
, -1
, ABS(ACCTD_EARNED_DISCOUNT_TAKEN)
, NULL)
, DECODE(SIGN(MCRA.ACCTD_EARNED_DISCOUNT_TAKEN)
, 1
, ACCTD_EARNED_DISCOUNT_TAKEN
, NULL)
, '_LA:DECODE(MCRA.POSTING_CONTROL_ID
, -3
, ''N''
, ''Y''):AR_LOOKUPS:YES/NO:MEANING'
, /* RESOLVED FK RESOLUTIONS */ SOB.NAME
, /* IDS */ MCRA.RECEIVABLE_APPLICATION_ID
, '_LA:''EDISC'':AR_LOOKUPS:ACCOUNT_TYPE:MEANING'
, MCRA.SET_OF_BOOKS_ID /* WHO COLUMNS */
FROM AR_MC_RECEIVABLE_APPS MCRA
, GL_SETS_OF_BOOKS SOB
WHERE MCRA.ACCTD_EARNED_DISCOUNT_TAKEN IS NOT NULL
AND MCRA.ACCTD_EARNED_DISCOUNT_TAKEN <> 0
AND MCRA.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID UNION SELECT /* UNEARNED DISCOUNT DISTRIBUTIONS */ /* UNIQUE ATTRIBUTES */ /* REGULAR ATTRIBUTES */ DECODE(SIGN(MCRA.ACCTD_UNEARNED_DISCOUNT_TAKEN)
, -1
, ABS(ACCTD_UNEARNED_DISCOUNT_TAKEN)
, NULL)
, DECODE(SIGN(MCRA.ACCTD_UNEARNED_DISCOUNT_TAKEN)
, 1
, ACCTD_UNEARNED_DISCOUNT_TAKEN
, NULL)
, '_LA:DECODE(MCRA.POSTING_CONTROL_ID
, -3
, ''N''
, ''Y''):AR_LOOKUPS:YES/NO:MEANING'
, /* RESOLVED FK RESOLUTIONS */ SOB.NAME
, /* IDS */ MCRA.RECEIVABLE_APPLICATION_ID
, '_LA:''UEDISC'':AR_LOOKUPS:ACCOUNT_TYPE:MEANING'
, MCRA.SET_OF_BOOKS_ID /* WHO COLUMNS */
FROM AR_MC_RECEIVABLE_APPS MCRA
, GL_SETS_OF_BOOKS SOB
WHERE MCRA.ACCTD_UNEARNED_DISCOUNT_TAKEN IS NOT NULL
AND MCRA.ACCTD_UNEARNED_DISCOUNT_TAKEN <> 0
AND MCRA.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID UNION SELECT /* EXCHANGE GAIN/LOSS DISTRIBUTIONS */ /* UNIQUE ATTRIBUTES */ /* REGULAR ATTRIBUTES */ DECODE(SIGN(MCRA.ACCTD_AMOUNT_APPLIED_FROM- MCRA.ACCTD_AMOUNT_APPLIED_TO)
, -1
, ABS(MCRA.ACCTD_AMOUNT_APPLIED_FROM- MCRA.ACCTD_AMOUNT_APPLIED_TO)
, NULL)
, DECODE(SIGN(MCRA.ACCTD_AMOUNT_APPLIED_FROM- MCRA.ACCTD_AMOUNT_APPLIED_TO)
, 1
, (MCRA.ACCTD_AMOUNT_APPLIED_FROM- MCRA.ACCTD_AMOUNT_APPLIED_TO)
, NULL)
, '_LA:DECODE(MCRA.POSTING_CONTROL_ID
, -3
, ''N''
, ''Y''):AR_LOOKUPS:YES/NO:MEANING'
, /* RESOLVED FK RESOLUTIONS */ SOB.NAME
, /* IDS */ MCRA.RECEIVABLE_APPLICATION_ID
, '_LA:DECODE(SIGN(MCRA.ACCTD_AMOUNT_APPLIED_FROM- MCRA.ACCTD_AMOUNT_APPLIED_TO)
, -1
, ''EXCH_LOSS''
, 1
, ''EXCH_GAIN''):AR_LOOKUPS:ACCOUNT_TYPE:MEANING'
, MCRA.SET_OF_BOOKS_ID /* WHO COLUMNS */
FROM AR_MC_RECEIVABLE_APPS MCRA
, GL_SETS_OF_BOOKS SOB
WHERE MCRA.ACCTD_AMOUNT_APPLIED_FROM <> MCRA.ACCTD_AMOUNT_APPLIED_TO
AND MCRA.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID WITH READ ONLY