View: ARBV_REVENUE_DISTRIBUTIONS

Product:	AR - Receivables
Description:	This shows information about revenue amounts posted to the General Ledger.
Implementation/DBA Data:	APPS.ARBV_REVENUE_DISTRIBUTIONS

View Text

SELECT /* UNIQUE ATTRIBUTES */ TLGD.CUST_TRX_LINE_GL_DIST_ID
, /* REGULAR ATTRIBUTES */ '_LA:TLGD.ACCOUNT_CLASS:AR_LOOKUPS:AUTOGL_TYPE:MEANING'
, DECODE(SIGN(TLGD.AMOUNT)
, -1
, ABS(TLGD.AMOUNT)
, NULL)
, DECODE(SIGN(TLGD.AMOUNT)
, 1
, TLGD.AMOUNT
, NULL)
, DECODE(SIGN(TLGD.ACCTD_AMOUNT)
, -1
, ABS(TLGD.ACCTD_AMOUNT)
, NULL)
, DECODE(SIGN(TLGD.ACCTD_AMOUNT)
, 1
, TLGD.ACCTD_AMOUNT
, NULL)
, TLGD.GL_DATE
, '_LA:DECODE(HED.GL_TRANSFER_STATUS_CODE
, ''Y''
, ''Y''
, ''N''):AR_LOOKUPS:YES/NO:MEANING'
, /* IDS */ TLGD.CUSTOMER_TRX_ID
, TLGD.CUSTOMER_TRX_LINE_ID
, TLGD.CUST_TRX_LINE_SALESREP_ID
, TLGD.CODE_COMBINATION_ID
, TLGD.ORG_ID
, /* WHO COLUMNS */ TLGD.LAST_UPDATE_DATE
, TLGD.LAST_UPDATED_BY
, TLGD.CREATION_DATE
, TLGD.CREATED_BY
FROM AR_XLA_CTLGD_LINES_V TLGD
, XLA_AE_HEADERS HED
WHERE TLGD.ACCOUNT_CLASS = 'REV'
AND TLGD.AE_HEADER_ID = HED.AE_HEADER_ID WITH READ ONLY

Columns