View: ARBV_APP_DISTS_ALT_CRNCY

Product:	AR - Receivables
Description:	- Retrofitted
Implementation/DBA Data:	APPS.ARBV_APP_DISTS_ALT_CRNCY

View Text

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'
, /* 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 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'
, /* 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
WHERE MCRA.ACCTD_EARNED_DISCOUNT_TAKEN IS NOT NULL
AND MCRA.ACCTD_EARNED_DISCOUNT_TAKEN <> 0 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'
, /* IDS */ MCRA.RECEIVABLE_APPLICATION_ID
, '_LA:''UNDISC'':AR_LOOKUPS:ACCOUNT_TYPE:MEANING'
, MCRA.SET_OF_BOOKS_ID /* WHO COLUMNS */
FROM AR_MC_RECEIVABLE_APPS MCRA
WHERE MCRA.ACCTD_UNEARNED_DISCOUNT_TAKEN IS NOT NULL
AND MCRA.ACCTD_UNEARNED_DISCOUNT_TAKEN <> 0 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'
, /* 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
WHERE MCRA.ACCTD_AMOUNT_APPLIED_FROM <> MCRA.ACCTD_AMOUNT_APPLIED_TO WITH READ ONLY

Columns