View: PSA_MF_PAYMENT_SCHEDULES_V

Product:	PSA - Public Sector Financials
Description:	All Multi-fund transactions except adjustments and miscellaneous cash receipts
Implementation/DBA Data:	APPS.PSA_MF_PAYMENT_SCHEDULES_V

View Text

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

Columns