View: LNS_REC_ACT_ADJ_V

Product:	LNS - Loans
Description:	Receipts and Creadit Memo Receivable Activities View
Implementation/DBA Data:	APPS.LNS_REC_ACT_ADJ_V

View Text

SELECT DISTINCT LOAN.LOAN_ID
, AM.AMORTIZATION_SCHEDULE_ID
, AM.PAYMENT_NUMBER
, AM.DUE_DATE
, TRX.CUSTOMER_TRX_ID
, TRX_PSA.PAYMENT_SCHEDULE_ID
, AML.LINE_TYPE
, LOK2.MEANING
, DECODE(ADJ.CUSTOMER_TRX_LINE_ID
, NULL
, 'ENTIRE TRANSACTION'
, LINES.DESCRIPTION)
, TRX.TRX_NUMBER
, ARL_CLA.LOOKUP_CODE
, ARL_CLA.MEANING || ' - ' || REC_TRX.NAME
, ADJ.AMOUNT
, ADJ.ADJUSTMENT_NUMBER
, ADJ.APPLY_DATE
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, ADJ.ADJUSTMENT_ID
, ADJ.CREATION_DATE
, ADJ.CREATED_BY
, ADJ.LAST_UPDATE_LOGIN
, ADJ.LAST_UPDATE_DATE
, ADJ.LAST_UPDATED_BY
, TRX_PSA.INVOICE_CURRENCY_CODE
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, LOAN.ORG_ID
, LOAN.LEGAL_ENTITY_ID
, NVL(AM.PHASE
, 'TERM')
FROM RA_CUSTOMER_TRX_ALL TRX
, RA_CUSTOMER_TRX_LINES_ALL LINES
, AR_PAYMENT_SCHEDULES_ALL TRX_PSA
, AR_ADJUSTMENTS_ALL ADJ
, AR_RECEIVABLES_TRX_ALL REC_TRX
, LNS_LOAN_HEADERS_ALL LOAN
, LNS_AMORTIZATION_SCHEDS AM
, LNS_AMORTIZATION_LINES AML
, LNS_LOOKUPS LOK2
, AR_LOOKUPS ARL_CLA
WHERE LOAN.LOAN_ID = AM.LOAN_ID
AND AML.LOAN_ID = LOAN.LOAN_ID
AND AML.AMORTIZATION_SCHEDULE_ID = AM.AMORTIZATION_SCHEDULE_ID
AND TRX.CUSTOMER_TRX_ID = AML.CUST_TRX_ID
AND TRX.CUSTOMER_TRX_ID = TRX_PSA.CUSTOMER_TRX_ID
AND TRX.CUSTOMER_TRX_ID = LINES.CUSTOMER_TRX_ID
AND TRX_PSA.PAYMENT_SCHEDULE_ID = ADJ.PAYMENT_SCHEDULE_ID
AND LINES.CUSTOMER_TRX_LINE_ID = AML.CUST_TRX_LINE_ID
AND ADJ.RECEIVABLES_TRX_ID = REC_TRX.RECEIVABLES_TRX_ID
AND ADJ.ORG_ID = REC_TRX.ORG_ID
AND LOK2.LOOKUP_TYPE = 'PAYMENT_APPLICATION_TYPE'
AND LOK2.LOOKUP_CODE = AML.LINE_TYPE
AND ARL_CLA.LOOKUP_CODE = 'ADJUSTMENT'
AND ARL_CLA.LOOKUP_TYPE = 'MISC_PHRASES'
AND ADJ.POSTABLE = 'Y'
AND ADJ.STATUS = 'A'
AND ((ADJ.CUSTOMER_TRX_LINE_ID IS NULL) OR (AML.CUST_TRX_LINE_ID = ADJ.CUSTOMER_TRX_LINE_ID
AND ADJ.CUSTOMER_TRX_LINE_ID IS NOT NULL))

Columns