View: AR_LINE_CONTINGENCIES_V

Product:	AR - Receivables
Description:	Holds contingency information for a deferred billing line.
Implementation/DBA Data:	APPS.AR_LINE_CONTINGENCIES_V

View Text

SELECT MAX(GSB.NAME) SET_OF_BOOKS_NAME
, MAX(GSB.SET_OF_BOOKS_ID) SET_OF_BOOKS_ID
, MAX(GSB.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(ARPT_SQL_FUNC_UTIL.GET_SALESREP_NAME_NUMBER (RCT.PRIMARY_SALESREP_ID
, 'NAME'
, LRS.ORG_ID)) SALESREP_NAME
, 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(DR.CONTINGENCY_NAME) REVENUE_CONTINGENCY
, MAX(LE.MEANING) REVREC_EVENT
, MAX(LRC.EXPIRATION_DATE) EXPIRATION_DATE
, MAX(LRC.REASON_REMOVAL_DATE) REASON_REMOVAL_DATE
, MAX(LRS.ACCTD_AMOUNT_RECOGNIZED) SCHEDULED_REVENUE
, MAX( LRS.ACCTD_AMOUNT_DUE_ORIGINAL + ARP_BAL_UTIL.GET_LINE_CM(RCTL.CUSTOMER_TRX_LINE_ID) - LRS.ACCTD_AMOUNT_RECOGNIZED) UNSCHEDULED_REVENUE
, MAX(ARP_BAL_UTIL.GET_LINE_CM(RCTL.CUSTOMER_TRX_LINE_ID)) CREDIT_MEMOS
FROM AR_DEFERRED_LINES LRS
, AR_LINE_CONTS LRC
, RA_CUSTOMER_TRX_LINES RCTL
, RA_CUSTOMER_TRX RCT
, RA_RULES RR
, AR_LOOKUPS LE
, /* EVENT LOOKUP */ AR_DEFERRAL_REASONS DR
, RA_CUST_TRX_LINE_GL_DIST GLDIST
, /* REC */ GL_SETS_OF_BOOKS GSB
, HZ_CUST_ACCOUNTS HCA
, HZ_PARTIES HP
WHERE LRS.CUSTOMER_TRX_LINE_ID = LRC.CUSTOMER_TRX_LINE_ID
AND LRC.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 GLDIST.ACCOUNT_CLASS = 'REC'
AND GLDIST.LATEST_REC_FLAG = 'Y'
AND GLDIST.SET_OF_BOOKS_ID = GSB.SET_OF_BOOKS_ID
AND RCTL.ACCOUNTING_RULE_ID = RR.RULE_ID (+)
AND LRC.CONTINGENCY_ID = DR.CONTINGENCY_ID
AND DR.REVREC_EVENT_CODE = LE.LOOKUP_CODE
AND LE.LOOKUP_TYPE = 'AR_REVREC_EVENTS'
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 = 'N' GROUP BY LRC.CUSTOMER_TRX_LINE_ID
, LRC.CONTINGENCY_ID

Columns