View: AR_BR_ACTIVITIES_V

Product:	AR - Receivables
Description:	(Release 115 Only)
Implementation/DBA Data:	APPS.AR_BR_ACTIVITIES_V

View Text

SELECT REC_APP.ROWID
, REC_APP.RECEIVABLE_APPLICATION_ID
, REC_APP.CASH_RECEIPT_ID
, RCP_SCH.TRX_NUMBER
, REC_APP.APPLIED_CUSTOMER_TRX_ID
, REC_APP.APPLY_DATE
, REC_APP.GL_DATE
, ARL_CLA.LOOKUP_CODE
, ARL_CLA.MEANING
, TRX_SCH.AMOUNT_DUE_ORIGINAL
, TRX_SCH.AMOUNT_APPLIED
, TO_NUMBER(NULL)
, /* BR_AMOUNT_ADJUSTED DOES NOT EXIST
, */ TO_NUMBER(NULL)
, /*BR_AMOUNT_EXCHANGED DOES NOT EXIST
, */ TRX_SCH.AMOUNT_DUE_REMAINING
, TRX_SCH.ACCTD_AMOUNT_DUE_REMAINING
, -REC_APP.AMOUNT_APPLIED
, REC_APP.APPLICATION_TYPE
, ARL_TYP.MEANING
, RCP_SCH.INVOICE_CURRENCY_CODE
, TRX_SCH.EXCHANGE_RATE
, REC_APP.STATUS
, ARL_STA.MEANING
, REC_APP.CREATION_DATE
, REC_APP.CREATED_BY
, REC_APP.LAST_UPDATE_LOGIN
, REC_APP.LAST_UPDATE_DATE
, REC_APP.LAST_UPDATED_BY
FROM AR_RECEIVABLE_APPLICATIONS REC_APP
, AR_PAYMENT_SCHEDULES RCP_SCH
, AR_PAYMENT_SCHEDULES TRX_SCH
, RA_CUST_TRX_TYPES TRX_TYP
, AR_LOOKUPS ARL_TYP
, AR_LOOKUPS ARL_STA
, AR_LOOKUPS ARL_CLA
WHERE REC_APP.PAYMENT_SCHEDULE_ID = RCP_SCH.PAYMENT_SCHEDULE_ID
AND REC_APP.APPLIED_CUSTOMER_TRX_ID = TRX_SCH.CUSTOMER_TRX_ID
AND TRX_SCH.CUST_TRX_TYPE_ID = TRX_TYP.CUST_TRX_TYPE_ID
AND ARL_CLA.LOOKUP_CODE = RCP_SCH.CLASS
AND ARL_CLA.LOOKUP_TYPE = 'INV/CM'
AND ARL_STA.LOOKUP_CODE = REC_APP.STATUS
AND ARL_STA.LOOKUP_TYPE = 'PAYMENT_TYPE'
AND ARL_TYP.LOOKUP_CODE = REC_APP.APPLICATION_TYPE
AND ARL_TYP.LOOKUP_TYPE = 'APPLICATION_TYPE'
AND REC_APP.APPLIED_PAYMENT_SCHEDULE_ID <> -2 /* STD SHOULD NOT BE DIPLAYED IN HISTORY WINDOW.*/
AND TRX_TYP.TYPE = 'BR'
AND ARL_CLA.LOOKUP_CODE <> 'CM'
AND REC_APP.STATUS = 'APP' UNION ALL SELECT ADJ.ROWID
, ADJ.ADJUSTMENT_ID
, ADJ.ADJUSTMENT_ID
, ADJ.ADJUSTMENT_NUMBER
, ADJ.CUSTOMER_TRX_ID
, ADJ.APPLY_DATE
, ADJ.GL_DATE
, ARL_CLA.LOOKUP_CODE
, ARL_CLA.MEANING
, TRX_SCH.AMOUNT_DUE_ORIGINAL
, TO_NUMBER(NULL)
, /*BR_AMOUNT_APPLIED DOES NOT EXIST
, */ TRX_SCH.AMOUNT_ADJUSTED
, TO_NUMBER(NULL)
, /* BR_AMOUNT_EXCHANGED DOES NOT EXIST
, */ TRX_SCH.AMOUNT_DUE_REMAINING
, TRX_SCH.ACCTD_AMOUNT_DUE_REMAINING
, ADJ.AMOUNT
, NULL
, /* NO TYPE IS REQUIRED FOR ADJUSTMENTS. */ NULL
, /*NO TYPE IS REQUIRED FOR ADJUSTMENTS. */ TRX_SCH.INVOICE_CURRENCY_CODE
, TRX_SCH.EXCHANGE_RATE
, NULL
, /* NO STATUS IS REQUIRED FOR ADJUSTMENTS. */ NULL
, /* NO STATUS IS REQUIRED FOR ADJUSTMENTS. */ ADJ. CREATION_DATE
, ADJ. CREATED_BY
, ADJ. LAST_UPDATE_LOGIN
, ADJ. LAST_UPDATE_DATE
, ADJ. LAST_UPDATED_BY
FROM AR_PAYMENT_SCHEDULES TRX_SCH
, AR_ADJUSTMENTS ADJ
, RA_CUST_TRX_TYPES TRX_TYP
, AR_LOOKUPS ARL_CLA
WHERE ADJ.PAYMENT_SCHEDULE_ID = TRX_SCH.PAYMENT_SCHEDULE_ID
AND TRX_SCH.CUST_TRX_TYPE_ID = TRX_TYP.CUST_TRX_TYPE_ID
AND ARL_CLA.LOOKUP_CODE = 'ADJUSTMENT'
AND ARL_CLA.LOOKUP_TYPE = 'MISC_PHRASES'
AND ADJ.POSTABLE = 'Y'
AND ADJ.STATUS = 'A'
AND TRX_TYP.TYPE = 'BR' UNION ALL SELECT ADJ_EXCH.ROWID
, ADJ_EXCH.ADJUSTMENT_ID
, ADJ_EXCH.ADJUSTMENT_ID
, ADJ_EXCH.ADJUSTMENT_NUMBER
, ADJ_EXCH.CUSTOMER_TRX_ID
, ADJ_EXCH.APPLY_DATE
, ADJ_EXCH.GL_DATE
, ARL_CLA.LOOKUP_CODE
, ARL_CLA.MEANING
, TRX_SCH.AMOUNT_DUE_ORIGINAL
, TO_NUMBER(NULL)
, /* BR_AMOUNT_APPLIED DOES NOT EXIST
, */ TO_NUMBER(NULL)
, /* BR_ADJUSTMENT_APPLIED DOES NOT EXIST
, */ TRX_SCH.AMOUNT_ADJUSTED
, /* AMOUNT EXHANGED */ TRX_SCH.AMOUNT_DUE_REMAINING
, TRX_SCH.ACCTD_AMOUNT_DUE_REMAINING
, ADJ_EXCH.AMOUNT
, NULL
, /* NO TYPE IS REQUIRED FOR EXCHANGES.*/ NULL
, /* NO TYPE IS REQUIRED FOR EXCHANGES. */ TRX_SCH.INVOICE_CURRENCY_CODE
, TRX_SCH.EXCHANGE_RATE
, NULL
, /* NO STATUS IS REQUIRED FOR EXCHANGES. */ NULL
, /* NO STATUS IS REQUIRED FOR EXCHANGES. */ ADJ_EXCH. CREATION_DATE
, ADJ_EXCH. CREATED_BY
, ADJ_EXCH. LAST_UPDATE_LOGIN
, ADJ_EXCH. LAST_UPDATE_DATE
, ADJ_EXCH. LAST_UPDATED_BY
FROM AR_PAYMENT_SCHEDULES TRX_SCH
, AR_ADJUSTMENTS ADJ_EXCH
, AR_LOOKUPS ARL_CLA
WHERE EXISTS (SELECT '' FROM AR_TRANSACTION_HISTORY_ALL HIST WHERE ADJ_EXCH.CUSTOMER_TRX_ID = HIST.CUSTOMER_TRX_ID AND HIST.EVENT = 'EXCHANGED' )
AND ADJ_EXCH.PAYMENT_SCHEDULE_ID = TRX_SCH.PAYMENT_SCHEDULE_ID
AND ARL_CLA.LOOKUP_CODE = 'ASSIGNMENT'
AND ARL_CLA.LOOKUP_TYPE = 'MISC_PHRASES'
AND ADJ_EXCH.POSTABLE = 'N'
AND ADJ_EXCH.STATUS = 'A'

Columns