VIEW: APPS.ARFV_CASH_APPLICATIONS

Source

View Text - Preformatted

SELECT /* UNIQUE ATTRIBUTES */ RA.RECEIVABLE_APPLICATION_ID , /* REGULAR ATTRIBUTES */ RA.AMOUNT_APPLIED , RA.ACCTD_AMOUNT_APPLIED_TO , RA.AMOUNT_APPLIED_FROM , RA.ACCTD_AMOUNT_APPLIED_FROM , RA.TRANS_TO_RECEIPT_RATE , RA.APPLY_DATE , '_LA:RA.STATUS:AR_LOOKUPS:PAYMENT_TYPE:MEANING' , RA.LINE_APPLIED , RA.TAX_APPLIED , RA.FREIGHT_APPLIED , RA.RECEIVABLES_CHARGES_APPLIED , RA.EARNED_DISCOUNT_TAKEN , RA.UNEARNED_DISCOUNT_TAKEN , RA.ACCTD_EARNED_DISCOUNT_TAKEN , RA.ACCTD_UNEARNED_DISCOUNT_TAKEN , RA.LINE_EDISCOUNTED , RA.TAX_EDISCOUNTED , RA.FREIGHT_EDISCOUNTED , RA.CHARGES_EDISCOUNTED , RA.LINE_UEDISCOUNTED , RA.TAX_UEDISCOUNTED , RA.FREIGHT_UEDISCOUNTED , RA.CHARGES_UEDISCOUNTED , RA.DAYS_LATE , '_LA:RA.CONFIRMED_FLAG:AR_LOOKUPS:YES/NO:MEANING' , RA.USSGL_TRANSACTION_CODE , RA.COMMENTS , '_DF:AR:AR_RECEIVABLE_APPLICATIONS:RA' , '_DF:JG:JG_AR_RECEIVABLE_APPLICATIONS:RA' , /* RESOLVED FK RESOLUTIONS */ AOU.NAME , CR.RECEIPT_NUMBER , PS.TRX_NUMBER , CTL.LINE_NUMBER , /* IDS */ RA.ORG_ID , RA.CASH_RECEIPT_ID , RA.APPLIED_PAYMENT_SCHEDULE_ID , RA.APPLIED_CUSTOMER_TRX_LINE_ID , /* WHO COLUMNS */ RA.LAST_UPDATE_DATE , RA.LAST_UPDATED_BY , RA.CREATION_DATE , RA.CREATED_BY FROM AR_RECEIVABLE_APPLICATIONS RA, HR_ALL_ORGANIZATION_UNITS AOU, AR_CASH_RECEIPTS CR, AR_PAYMENT_SCHEDULES PS, RA_CUSTOMER_TRX_LINES CTL WHERE RA.APPLICATION_TYPE = 'CASH' AND RA.ORG_ID = AOU.ORGANIZATION_ID(+) AND RA.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID AND RA.APPLIED_PAYMENT_SCHEDULE_ID = PS.PAYMENT_SCHEDULE_ID(+) AND RA.APPLIED_CUSTOMER_TRX_LINE_ID = CTL.CUSTOMER_TRX_LINE_ID(+) WITH READ ONLY

View Text - HTML Formatted

SELECT /* UNIQUE ATTRIBUTES */ RA.RECEIVABLE_APPLICATION_ID
, /* REGULAR ATTRIBUTES */ RA.AMOUNT_APPLIED
, RA.ACCTD_AMOUNT_APPLIED_TO
, RA.AMOUNT_APPLIED_FROM
, RA.ACCTD_AMOUNT_APPLIED_FROM
, RA.TRANS_TO_RECEIPT_RATE
, RA.APPLY_DATE
, '_LA:RA.STATUS:AR_LOOKUPS:PAYMENT_TYPE:MEANING'
, RA.LINE_APPLIED
, RA.TAX_APPLIED
, RA.FREIGHT_APPLIED
, RA.RECEIVABLES_CHARGES_APPLIED
, RA.EARNED_DISCOUNT_TAKEN
, RA.UNEARNED_DISCOUNT_TAKEN
, RA.ACCTD_EARNED_DISCOUNT_TAKEN
, RA.ACCTD_UNEARNED_DISCOUNT_TAKEN
, RA.LINE_EDISCOUNTED
, RA.TAX_EDISCOUNTED
, RA.FREIGHT_EDISCOUNTED
, RA.CHARGES_EDISCOUNTED
, RA.LINE_UEDISCOUNTED
, RA.TAX_UEDISCOUNTED
, RA.FREIGHT_UEDISCOUNTED
, RA.CHARGES_UEDISCOUNTED
, RA.DAYS_LATE
, '_LA:RA.CONFIRMED_FLAG:AR_LOOKUPS:YES/NO:MEANING'
, RA.USSGL_TRANSACTION_CODE
, RA.COMMENTS
, '_DF:AR:AR_RECEIVABLE_APPLICATIONS:RA'
, '_DF:JG:JG_AR_RECEIVABLE_APPLICATIONS:RA'
, /* RESOLVED FK RESOLUTIONS */ AOU.NAME
, CR.RECEIPT_NUMBER
, PS.TRX_NUMBER
, CTL.LINE_NUMBER
, /* IDS */ RA.ORG_ID
, RA.CASH_RECEIPT_ID
, RA.APPLIED_PAYMENT_SCHEDULE_ID
, RA.APPLIED_CUSTOMER_TRX_LINE_ID
, /* WHO COLUMNS */ RA.LAST_UPDATE_DATE
, RA.LAST_UPDATED_BY
, RA.CREATION_DATE
, RA.CREATED_BY
FROM AR_RECEIVABLE_APPLICATIONS RA
, HR_ALL_ORGANIZATION_UNITS AOU
, AR_CASH_RECEIPTS CR
, AR_PAYMENT_SCHEDULES PS
, RA_CUSTOMER_TRX_LINES CTL
WHERE RA.APPLICATION_TYPE = 'CASH'
AND RA.ORG_ID = AOU.ORGANIZATION_ID(+)
AND RA.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
AND RA.APPLIED_PAYMENT_SCHEDULE_ID = PS.PAYMENT_SCHEDULE_ID(+)
AND RA.APPLIED_CUSTOMER_TRX_LINE_ID = CTL.CUSTOMER_TRX_LINE_ID(+) WITH READ ONLY