eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_LTE_INT_PVT dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 29: l_amt_applied AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%type;

25: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
26: l_init_msg_list VARCHAR2(1) ;
27: l_msg_count NUMBER ;
28:
29: l_amt_applied AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%type;
30: l_due_date AR_PAYMENT_SCHEDULES_ALL.DUE_DATE%type;
31: l_khr_id OKL_CNSLD_AR_STRMS_V.KHR_ID%type;
32:
33: --Bug# 11076575: Changed l_apply_date to l_receipt_date

Line 126: FROM AR_RECEIVABLE_APPLICATIONS_ALL AR_REC

122: , SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) AMOUNT_APPLIED
123: , max(greatest(TRUNC((FND_DATE.canonical_to_date(NVL(rul_hld.rule_information1,AR_PAY.DUE_DATE)))),TRUNC(AR_PAY.DUE_DATE))) DUE_DATE
124: , TRUNC(CRA.RECEIPT_DATE) RECEIPT_DATE
125: ,max('AR-INVOICE') invoice_flag
126: FROM AR_RECEIVABLE_APPLICATIONS_ALL AR_REC
127: , AR_PAYMENT_SCHEDULES_ALL AR_PAY
128: , OKL_K_HEADERS_FULL_V KHR
129: , OKC_RULE_GROUPS_B RGP
130: , OKC_RULES_B RUL

Line 199: FROM AR_RECEIVABLE_APPLICATIONS_ALL AR_REC

195: , SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) AMOUNT_APPLIED
196: , max(greatest(TRUNC((FND_DATE.canonical_to_date(NVL(rul_hld.rule_information1,AR_PAY.DUE_DATE)))),TRUNC(AR_PAY.DUE_DATE))) DUE_DATE
197: , TRUNC(CRA.RECEIPT_DATE) RECEIPT_DATE
198: ,max('AR-INVOICE') invoice_flag
199: FROM AR_RECEIVABLE_APPLICATIONS_ALL AR_REC
200: , AR_PAYMENT_SCHEDULES_ALL AR_PAY
201: , OKL_K_HEADERS_FULL_V KHR
202: , OKC_RULE_GROUPS_B RGP
203: , OKC_RULES_B RUL

Line 284: FROM AR_RECEIVABLE_APPLICATIONS_ALL AR_REC

280: , sum(NVL(AR_REC.AMOUNT_APPLIED,0)) AMOUNT_APPLIED
281: , max(greatest(TRUNC((FND_DATE.canonical_to_date(NVL(rul_hld.rule_information1,AR_PAY.DUE_DATE)))),TRUNC(AR_PAY.DUE_DATE))) DUE_DATE
282: , TRUNC(CRA.RECEIPT_DATE) RECEIPT_DATE
283: , max('CONS-INVOICE') invoice_flag
284: FROM AR_RECEIVABLE_APPLICATIONS_ALL AR_REC
285: , AR_PAYMENT_SCHEDULES_ALL AR_PAY
286: , OKL_CNSLD_AR_STRMS_B CNSLD
287: , OKL_K_HEADERS_FULL_V KHR
288: , OKC_RULE_GROUPS_B RGP