VIEW: APPS.AR_CASH_RECOS_PS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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