Product: | PSA - Public Sector Financials |
---|---|
Description: | All Credit Memo Distributions applied to Multi-Fund Invoices |
Implementation/DBA Data: | APPS.PSA_MF_CRM_DIST_V |
SELECT RCT.ROWID ROW_ID
, RCT.RECEIVABLE_APPLICATION_ID
, RCT.CUST_TRX_LINE_GL_DIST_ID
, PSATRX.MF_RECEIVABLES_CCID
, MF_CASH_CCID
, (RCT.AMOUNT*-1) AMOUNT
, RCT.PERCENT
, RCT.LAST_UPDATE_DATE
, RCT.LAST_UPDATED_BY
, RCT.DISCOUNT_CCID
, RCT.UE_DISCOUNT_CCID
, RCT.DISCOUNT_AMOUNT
, RCT.UE_DISCOUNT_AMOUNT
, RCT.COMMENTS
, RCT.CREATION_DATE
, RCT.CREATED_BY
, RCT.LAST_UPDATE_LOGIN
FROM PSA_MF_RCT_DIST_ALL RCT
, PSA_MF_TRX_DIST_ALL PSATRX
WHERE RCT.CUST_TRX_LINE_GL_DIST_ID =PSATRX.CUST_TRX_LINE_GL_DIST_ID