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_BILLING_UTIL_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 186: ar_payment_schedules_all sch,

182:
183: CURSOR tax_applied_csr(p_header_id NUMBER, p_line_id NUMBER) IS
184: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) tax_applied
185: FROM ar_receivable_applications_all app,
186: ar_payment_schedules_all sch,
187: ar_distributions_all ad,
188: ra_customer_trx_lines_all lines
189: WHERE app.status = 'APP'
190: AND app.applied_payment_schedule_id = sch.payment_schedule_id

Line 252: ar_payment_schedules_all sch,

248:
249: CURSOR tax_credited_csr(p_header_id NUMBER, p_line_id NUMBER) IS
250: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) credit_applied
251: FROM ar_receivable_applications_all app,
252: ar_payment_schedules_all sch,
253: ar_distributions_all ad,
254: ra_customer_trx_lines_all lines
255: WHERE app.status = 'APP'
256: AND app.applied_payment_schedule_id = sch.payment_schedule_id

Line 323: ar_payment_schedules_all sch,

319:
320: CURSOR c_line_applied_csr(p_header_id NUMBER, p_line_id NUMBER) IS
321: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) line_applied
322: FROM ar_receivable_applications_all app,
323: ar_payment_schedules_all sch,
324: ar_distributions_all ad
325: WHERE app.status = 'APP'
326: AND app.payment_schedule_id = sch.payment_schedule_id
327: AND sch.class IN ('CM') --Receipt can be applied against credit memo

Line 337: ar_payment_schedules_all sch,

333:
334: CURSOR c_tax_applied_csr(p_header_id NUMBER, p_line_id NUMBER) IS
335: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) tax_applied
336: FROM ar_receivable_applications_all app,
337: ar_payment_schedules_all sch,
338: ar_distributions_all ad,
339: ra_customer_trx_lines_all lines
340: WHERE app.status = 'APP'
341: AND app.payment_schedule_id = sch.payment_schedule_id

Line 439: FROM AR_PAYMENT_SCHEDULES_ALL APS,

435: FUNCTION INVOICE_AMOUNT_ORIG(
436: p_customer_trx_id IN NUMBER) RETURN NUMBER IS
437: CURSOR invoice_amount_orig_csr(p_header_id NUMBER) IS
438: SELECT SUM(NVL(APS.AMOUNT_DUE_ORIGINAL,0)) AMOUNT_DUE_ORIGINAL
439: FROM AR_PAYMENT_SCHEDULES_ALL APS,
440: RA_CUSTOMER_TRX_ALL RACTRX
441: WHERE RACTRX.CUSTOMER_TRX_ID = APS.CUSTOMER_TRX_ID
442: AND RACTRX.CUSTOMER_TRX_ID = p_header_id;
443: l_invoice_amount_orig NUMBER;

Line 458: ar_payment_schedules_all sch

454: --dkagrawa modified the cusrsor to add class CM
455: CURSOR invoice_amount_applied_csr(p_header_id NUMBER) IS
456: SELECT NVL(SUM(app.amount_applied),0) AMOUNT_APPLIED
457: FROM ar_receivable_applications_all app,
458: ar_payment_schedules_all sch
459: WHERE app.status = 'APP'
460: AND app.applied_payment_schedule_id = sch.payment_schedule_id
461: AND sch.class IN ('INV','CM') --Receipt can be applied against credit memo
462: AND sch.customer_trx_id = p_header_id

Line 478: ar_payment_schedules_all sch

474: p_customer_trx_id IN NUMBER) RETURN NUMBER IS
475: CURSOR invoice_amount_credited_csr(p_header_id NUMBER) IS
476: SELECT NVL(SUM(app.amount_applied),0) AMOUNT_CREDITED
477: FROM ar_receivable_applications_all app,
478: ar_payment_schedules_all sch
479: WHERE app.status = 'APP'
480: AND app.applied_payment_schedule_id = sch.payment_schedule_id
481: AND sch.class = 'INV'
482: AND sch.customer_trx_id = p_header_id

Line 497: FROM AR_PAYMENT_SCHEDULES_ALL APS,

493: FUNCTION INVOICE_AMOUNT_REMAINING(
494: p_customer_trx_id IN NUMBER) RETURN NUMBER IS
495: CURSOR invoice_amount_remaining_csr(p_header_id NUMBER) IS
496: SELECT SUM(NVL(APS.AMOUNT_DUE_REMAINING,0)) AMOUNT_DUE_REMAINING
497: FROM AR_PAYMENT_SCHEDULES_ALL APS,
498: RA_CUSTOMER_TRX_ALL RACTRX
499: WHERE RACTRX.CUSTOMER_TRX_ID = APS.CUSTOMER_TRX_ID
500: AND RACTRX.CUSTOMER_TRX_ID = p_header_id;
501: l_invoice_amount_remaining NUMBER;

Line 1318: FROM AR_PAYMENT_SCHEDULES_ALL APS,

1314: FUNCTION INV_AMT_REMAINING_WOTAX(
1315: p_customer_trx_id IN NUMBER) RETURN NUMBER IS
1316: CURSOR invoice_amount_remaining_csr(p_header_id NUMBER) IS
1317: SELECT SUM(NVL(APS.AMOUNT_DUE_REMAINING,0)) AMOUNT_DUE_REMAINING
1318: FROM AR_PAYMENT_SCHEDULES_ALL APS,
1319: RA_CUSTOMER_TRX_ALL RACTRX
1320: WHERE RACTRX.CUSTOMER_TRX_ID = APS.CUSTOMER_TRX_ID
1321: AND RACTRX.CUSTOMER_TRX_ID = p_header_id;
1322: l_invoice_amount_remaining NUMBER;

Line 1362: ar_payment_schedules_all sch,

1358: p_customer_trx_line_id NUMBER) RETURN NUMBER IS
1359: CURSOR line_credited_csr(p_header_id NUMBER, p_line_id NUMBER) IS
1360: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) credit_applied
1361: FROM ar_receivable_applications_all app,
1362: ar_payment_schedules_all sch,
1363: ar_distributions_all ad
1364: WHERE app.status = 'APP'
1365: AND app.applied_payment_schedule_id = sch.payment_schedule_id
1366: AND sch.class = 'INV'

Line 1389: ar_payment_schedules_all sch,

1385: --dkagrawa modified the cusrsor to add class CM
1386: CURSOR line_applied_csr(p_header_id NUMBER, p_line_id NUMBER) IS
1387: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) line_applied
1388: FROM ar_receivable_applications_all app,
1389: ar_payment_schedules_all sch,
1390: ar_distributions_all ad
1391: WHERE app.status = 'APP'
1392: AND app.applied_payment_schedule_id = sch.payment_schedule_id
1393: AND sch.class IN ('INV','CM') --Receipt can be applied against credit memo

Line 1416: FROM AR_PAYMENT_SCHEDULES_ALL APS,

1412: FUNCTION INVOICE_AMOUNT_ADJUSTED(
1413: p_customer_trx_id IN NUMBER) RETURN NUMBER IS
1414: CURSOR invoice_amount_adj_csr(p_header_id NUMBER) IS
1415: SELECT SUM(NVL(APS.AMOUNT_ADJUSTED,0)) AMOUNT_ADJUSTED
1416: FROM AR_PAYMENT_SCHEDULES_ALL APS,
1417: RA_CUSTOMER_TRX_ALL RACTRX
1418: WHERE RACTRX.CUSTOMER_TRX_ID = APS.CUSTOMER_TRX_ID
1419: AND RACTRX.CUSTOMER_TRX_ID = p_header_id;
1420: l_invoice_amount_adj NUMBER;

Line 1436: ar_payment_schedules_all sch,

1432:
1433: CURSOR invoice_ln_tax_adj(p_header_id NUMBER, p_line_id NUMBER) IS
1434: SELECT SUM(nvl(dist.amount_cr,0))- SUM(nvl(dist.amount_dr,0)) tax_adjusted
1435: FROM ar_adjustments_all adj,
1436: ar_payment_schedules_all sch,
1437: ar_distributions_all dist,
1438: ra_customer_trx_lines_all lines
1439: WHERE adj.payment_schedule_id = sch.payment_schedule_id
1440: AND sch.class = 'INV'

Line 1505: ar_payment_schedules_all aps

1501: CURSOR invoice_ln_amount_adj(p_header_id NUMBER, p_line_id NUMBER) IS
1502: SELECT SUM(nvl(dist.amount_cr,0))- SUM(nvl(dist.amount_dr,0)) amt_adjsuted
1503: FROM ar_distributions_all dist ,
1504: ar_adjustments_all adj ,
1505: ar_payment_schedules_all aps
1506: WHERE dist.source_table = 'ADJ'
1507: AND dist.source_id = adj.adjustment_id
1508: AND aps.customer_trx_id = p_header_id
1509: AND adj.payment_schedule_id = aps.payment_schedule_id

Line 1561: ar_payment_schedules_all sch,

1557:
1558: CURSOR tax_applied_csr(p_header_id NUMBER, p_line_id NUMBER) IS
1559: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) tax_applied
1560: FROM ar_receivable_applications_all app,
1561: ar_payment_schedules_all sch,
1562: ar_distributions_all ad,
1563: ra_customer_trx_lines_all lines
1564: WHERE app.status = 'APP'
1565: AND app.applied_payment_schedule_id = sch.payment_schedule_id

Line 1597: ar_payment_schedules_all sch,

1593:
1594: CURSOR tax_credited_csr(p_header_id NUMBER, p_line_id NUMBER) IS
1595: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) credit_applied
1596: FROM ar_receivable_applications_all app,
1597: ar_payment_schedules_all sch,
1598: ar_distributions_all ad,
1599: ra_customer_trx_lines_all lines
1600: WHERE app.status = 'APP'
1601: AND app.applied_payment_schedule_id = sch.payment_schedule_id

Line 1634: ar_payment_schedules_all sch,

1630:
1631: CURSOR invoice_ln_tax_adj(p_header_id NUMBER, p_line_id NUMBER) IS
1632: SELECT SUM(nvl(dist.amount_cr,0))- SUM(nvl(dist.amount_dr,0)) tax_adjusted
1633: FROM ar_adjustments_all adj,
1634: ar_payment_schedules_all sch,
1635: ar_distributions_all dist,
1636: ra_customer_trx_lines_all lines
1637: WHERE adj.payment_schedule_id = sch.payment_schedule_id
1638: AND sch.class = 'INV'