View: AR_CASH_RECOS_PS

Product:	AR - Receivables
Description:	View used to implement Recommendations UI
Implementation/DBA Data:	APPS.AR_CASH_RECOS_PS

View Text

SELECT CR.RECOMMENDATION_ID
, CR.REMIT_REFERENCE_ID
, CR.RESOLVED_MATCHING_NUMBER
, CR.MATCH_RESOLVED_USING
, CR.MATCH_SCORE_VALUE
, PS.PAYMENT_SCHEDULE_ID
, PS.CUSTOMER_TRX_ID
, PS.AMOUNT_DUE_ORIGINAL
, PS.AMOUNT_DUE_REMAINING
, PS.TRX_NUMBER
, PS.TRX_DATE
, PS.CLASS
, PS.INVOICE_CURRENCY_CODE
, CA.AUTOMATCH_NAME
, CUS.CUST_ACCOUNT_ID "CUSTOMER_ID"
, PAR.PARTY_NAME
FROM AR_CASH_RECOS CR
, AR_CASH_RECO_LINES CRL
, AR_PAYMENT_SCHEDULES PS
, HZ_CUST_ACCOUNTS CUS
, HZ_PARTIES PAR
, AR_CASH_AUTOMATCHES_VL CA
WHERE CR.RECOMMENDATION_ID = CRL.RECOMMENDATION_ID
AND CRL.PAYMENT_SCHEDULE_ID = PS.PAYMENT_SCHEDULE_ID
AND CUS.CUST_ACCOUNT_ID = CR.PAY_FROM_CUSTOMER
AND PAR.PARTY_ID = CUS.PARTY_ID
AND CA.AUTOMATCH_ID = CR.AUTOMATCH_ID

Columns