View: AR_LINE_EXCEPTIONS_V

Product:	AR - Receivables
Description:	Holds contingency information for a deferred billing line whose revenue has been adjusted.
Implementation/DBA Data:	APPS.AR_LINE_EXCEPTIONS_V

View Text

SELECT MAX(BOOKS.NAME) SET_OF_BOOKS_NAME
, MAX(BOOKS.SET_OF_BOOKS_ID) SET_OF_BOOKS_ID
, MAX(BOOKS.CURRENCY_CODE) CURRENCY_CODE
, MAX(HP.PARTY_NAME) CUSTOMER_NAME
, MAX(HCA.ACCOUNT_NUMBER) CUSTOMER_NUMBER
, MAX(RCT.TRX_NUMBER) TRX_NUMBER
, MAX(RCT.TRX_DATE) TRX_DATE
, MAX(GLDIST.GL_DATE) REC_GL_DATE
, MAX(GLDIST2.GL_DATE) GL_DATE
, MAX(ARPT_SQL_FUNC_UTIL.GET_REFERENCE(RCT.ROWID)) REFERENCE_NUMBER
, MAX(RCTL.LINE_NUMBER) LINE_NUMBER
, MAX(RCTL.DESCRIPTION) DESCRIPTION
, MAX(LRS.ACCTD_AMOUNT_DUE_ORIGINAL) LINE_AMOUNT
, MAX(RR.NAME) RULE_NAME
, MAX(ARPT_SQL_FUNC_UTIL.GET_SALESREP_NAME_NUMBER( RCT.PRIMARY_SALESREP_ID
, 'NAME')) SALESREP_NAME
, MAX(LRS.LAST_UPDATE_DATE) MANUAL_ADJUSTMENT_DATE
, SUM(DECODE(GLDIST2.ACCOUNT_CLASS
, 'UNEARN'
, GLDIST2.ACCTD_AMOUNT
, 0)) + MAX(ARP_BAL_UTIL.GET_LINE_CM(RCTL.CUSTOMER_TRX_LINE_ID)) UNEARNED_REVENUE
, SUM(DECODE(GLDIST2.ACCOUNT_CLASS
, 'REV'
, GLDIST2.ACCTD_AMOUNT
, 0)) REVENUE
, MAX(ARP_BAL_UTIL.GET_LINE_CM(RCTL.CUSTOMER_TRX_LINE_ID)) CREDIT_MEMOS
FROM AR_DEFERRED_LINES LRS
, RA_CUSTOMER_TRX_LINES RCTL
, RA_CUSTOMER_TRX RCT
, RA_RULES RR
, RA_CUST_TRX_LINE_GL_DIST GLDIST
, RA_CUST_TRX_LINE_GL_DIST GLDIST2
, GL_SETS_OF_BOOKS BOOKS
, HZ_CUST_ACCOUNTS HCA
, HZ_PARTIES HP
WHERE LRS.CUSTOMER_TRX_LINE_ID = RCTL.CUSTOMER_TRX_LINE_ID
AND RCTL.CUSTOMER_TRX_ID = RCT.CUSTOMER_TRX_ID
AND RCT.CUSTOMER_TRX_ID = GLDIST.CUSTOMER_TRX_ID
AND LRS.CUSTOMER_TRX_LINE_ID = GLDIST2.CUSTOMER_TRX_LINE_ID
AND GLDIST2.ACCOUNT_SET_FLAG = 'N'
AND GLDIST.ACCOUNT_CLASS = 'REC'
AND GLDIST.LATEST_REC_FLAG = 'Y'
AND RCTL.ACCOUNTING_RULE_ID = RR.RULE_ID (+)
AND GLDIST.SET_OF_BOOKS_ID = BOOKS.SET_OF_BOOKS_ID
AND RCT.BILL_TO_CUSTOMER_ID = HCA.CUST_ACCOUNT_ID
AND HCA.PARTY_ID = HP.PARTY_ID
AND LRS.LINE_COLLECTIBLE_FLAG = 'N'
AND LRS.MANUAL_OVERRIDE_FLAG = 'Y' GROUP BY LRS.CUSTOMER_TRX_LINE_ID

Columns