VIEW: APPS.PSA_MF_PAYMENT_SCHEDULES_V

Source

View Text - Preformatted

SELECT aps.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID, psa.CUST_TRX_LINE_GL_DIST_ID CUST_TRX_LINE_GL_DIST_ID, aps.DUE_DATE DUE_DATE, psa.AMOUNT_DUE_ORIGINAL AMOUNT_DUE_ORIGINAL, psa.AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING, psa.AMOUNT_CREDITED AMOUNT_CREDITED, aps.AMOUNT_IN_DISPUTE*gldist.percent AMOUNT_IN_DISPUTE, aps.amount_adjusted_pending*gldist.percent AMOUNT_ADJUSTED_PENDING, aps.STATUS STATUS, aps.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE, aps.CLASS CLASS, aps.CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID, aps.CUSTOMER_ID CUSTOMER_ID, aps.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID, aps.CUSTOMER_TRX_ID CUSTOMER_TRX_ID, aps.CASH_RECEIPT_ID CASH_RECEIPT_ID, aps.ASSOCIATED_CASH_RECEIPT_ID ASSOCIATED_CASH_RECEIPT_ID, aps.TERM_ID TERM_ID, aps.GL_DATE_CLOSED GL_DATE_CLOSED, aps.ACTUAL_DATE_CLOSED ACTUAL_DATE_CLOSED, psa.AMOUNT_APPLIED AMOUNT_APPLIED, psa.AMOUNT_ADJUSTED AMOUNT_ADJUSTED, aps.EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, aps.EXCHANGE_DATE EXCHANGE_DATE, aps.EXCHANGE_RATE EXCHANGE_RATE, aps.TRX_NUMBER TRX_NUMBER, aps.TRX_DATE TRX_DATE, aps.REVERSED_CASH_RECEIPT_ID REVERSED_CASH_RECEIPT_ID, aps.GL_DATE GL_DATE, psa.AMOUNT_DUE_REMAINING ACCTD_AMOUNT_DUE_REMAINING, aps.RECEIPT_CONFIRMED_FLAG RECEIPT_CONFIRMED_FLAG, aps.DISPUTE_DATE DISPUTE_DATE, aps.ORG_ID ORG_ID, aps.CONS_INV_ID cons_inv_id, psat.MF_RECEIVABLES_CCID MF_RECEIVABLES_CCID from AR_PAYMENT_SCHEDULES_ALL aps, PSA_MF_BALANCES_VIEW psa, PSA_MF_TRX_DIST_ALL psat, RA_CUSTOMER_TRX_ALL ract, RA_CUST_TRX_LINE_GL_DIST_ALL gldist WHERE aps.CUST_TRX_TYPE_ID in (select PSA_TRX_TYPE_ID from PSA_TRX_TYPES_ALL ) and psa.CUST_TRX_LINE_GL_DIST_ID = gldist.CUST_TRX_LINE_GL_DIST_ID and gldist.customer_trx_id = ract.customer_trx_id and ract.CUSTOMER_TRX_ID = aps.CUSTOMER_TRX_ID and psat.CUST_TRX_LINE_GL_DIST_ID = psa.CUST_TRX_LINE_GL_DIST_ID

View Text - HTML Formatted

SELECT APS.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, PSA.CUST_TRX_LINE_GL_DIST_ID CUST_TRX_LINE_GL_DIST_ID
, APS.DUE_DATE DUE_DATE
, PSA.AMOUNT_DUE_ORIGINAL AMOUNT_DUE_ORIGINAL
, PSA.AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING
, PSA.AMOUNT_CREDITED AMOUNT_CREDITED
, APS.AMOUNT_IN_DISPUTE*GLDIST.PERCENT AMOUNT_IN_DISPUTE
, APS.AMOUNT_ADJUSTED_PENDING*GLDIST.PERCENT AMOUNT_ADJUSTED_PENDING
, APS.STATUS STATUS
, APS.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, APS.CLASS CLASS
, APS.CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID
, APS.CUSTOMER_ID CUSTOMER_ID
, APS.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, APS.CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, APS.CASH_RECEIPT_ID CASH_RECEIPT_ID
, APS.ASSOCIATED_CASH_RECEIPT_ID ASSOCIATED_CASH_RECEIPT_ID
, APS.TERM_ID TERM_ID
, APS.GL_DATE_CLOSED GL_DATE_CLOSED
, APS.ACTUAL_DATE_CLOSED ACTUAL_DATE_CLOSED
, PSA.AMOUNT_APPLIED AMOUNT_APPLIED
, PSA.AMOUNT_ADJUSTED AMOUNT_ADJUSTED
, APS.EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, APS.EXCHANGE_DATE EXCHANGE_DATE
, APS.EXCHANGE_RATE EXCHANGE_RATE
, APS.TRX_NUMBER TRX_NUMBER
, APS.TRX_DATE TRX_DATE
, APS.REVERSED_CASH_RECEIPT_ID REVERSED_CASH_RECEIPT_ID
, APS.GL_DATE GL_DATE
, PSA.AMOUNT_DUE_REMAINING ACCTD_AMOUNT_DUE_REMAINING
, APS.RECEIPT_CONFIRMED_FLAG RECEIPT_CONFIRMED_FLAG
, APS.DISPUTE_DATE DISPUTE_DATE
, APS.ORG_ID ORG_ID
, APS.CONS_INV_ID CONS_INV_ID
, PSAT.MF_RECEIVABLES_CCID MF_RECEIVABLES_CCID
FROM AR_PAYMENT_SCHEDULES_ALL APS
, PSA_MF_BALANCES_VIEW PSA
, PSA_MF_TRX_DIST_ALL PSAT
, RA_CUSTOMER_TRX_ALL RACT
, RA_CUST_TRX_LINE_GL_DIST_ALL GLDIST
WHERE APS.CUST_TRX_TYPE_ID IN (SELECT PSA_TRX_TYPE_ID
FROM PSA_TRX_TYPES_ALL )
AND PSA.CUST_TRX_LINE_GL_DIST_ID = GLDIST.CUST_TRX_LINE_GL_DIST_ID
AND GLDIST.CUSTOMER_TRX_ID = RACT.CUSTOMER_TRX_ID
AND RACT.CUSTOMER_TRX_ID = APS.CUSTOMER_TRX_ID
AND PSAT.CUST_TRX_LINE_GL_DIST_ID = PSA.CUST_TRX_LINE_GL_DIST_ID