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 222: ar_payment_schedules_all sch,

218:
219: CURSOR tax_credited_csr(p_header_id NUMBER, p_line_id NUMBER) IS
220: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) credit_applied
221: FROM ar_receivable_applications_all app,
222: ar_payment_schedules_all sch,
223: ar_distributions_all ad,
224: ra_customer_trx_lines_all lines
225: WHERE app.status = 'APP'
226: AND app.applied_payment_schedule_id = sch.payment_schedule_id

Line 286: FROM AR_PAYMENT_SCHEDULES_ALL APS,

282: FUNCTION INVOICE_AMOUNT_ORIG(
283: p_customer_trx_id IN NUMBER) RETURN NUMBER IS
284: CURSOR invoice_amount_orig_csr(p_header_id NUMBER) IS
285: SELECT SUM(NVL(APS.AMOUNT_DUE_ORIGINAL,0)) AMOUNT_DUE_ORIGINAL
286: FROM AR_PAYMENT_SCHEDULES_ALL APS,
287: RA_CUSTOMER_TRX_ALL RACTRX
288: WHERE RACTRX.CUSTOMER_TRX_ID = APS.CUSTOMER_TRX_ID
289: AND RACTRX.CUSTOMER_TRX_ID = p_header_id;
290: l_invoice_amount_orig NUMBER;

Line 305: ar_payment_schedules_all sch

301: --dkagrawa modified the cusrsor to add class CM
302: CURSOR invoice_amount_applied_csr(p_header_id NUMBER) IS
303: SELECT NVL(SUM(app.amount_applied),0) AMOUNT_APPLIED
304: FROM ar_receivable_applications_all app,
305: ar_payment_schedules_all sch
306: WHERE app.status = 'APP'
307: AND app.applied_payment_schedule_id = sch.payment_schedule_id
308: AND sch.class IN ('INV','CM') --Receipt can be applied against credit memo
309: AND sch.customer_trx_id = p_header_id

Line 325: ar_payment_schedules_all sch

321: p_customer_trx_id IN NUMBER) RETURN NUMBER IS
322: CURSOR invoice_amount_credited_csr(p_header_id NUMBER) IS
323: SELECT NVL(SUM(app.amount_applied),0) AMOUNT_CREDITED
324: FROM ar_receivable_applications_all app,
325: ar_payment_schedules_all sch
326: WHERE app.status = 'APP'
327: AND app.applied_payment_schedule_id = sch.payment_schedule_id
328: AND sch.class = 'INV'
329: AND sch.customer_trx_id = p_header_id

Line 344: FROM AR_PAYMENT_SCHEDULES_ALL APS,

340: FUNCTION INVOICE_AMOUNT_REMAINING(
341: p_customer_trx_id IN NUMBER) RETURN NUMBER IS
342: CURSOR invoice_amount_remaining_csr(p_header_id NUMBER) IS
343: SELECT SUM(NVL(APS.AMOUNT_DUE_REMAINING,0)) AMOUNT_DUE_REMAINING
344: FROM AR_PAYMENT_SCHEDULES_ALL APS,
345: RA_CUSTOMER_TRX_ALL RACTRX
346: WHERE RACTRX.CUSTOMER_TRX_ID = APS.CUSTOMER_TRX_ID
347: AND RACTRX.CUSTOMER_TRX_ID = p_header_id;
348: l_invoice_amount_remaining NUMBER;

Line 1165: FROM AR_PAYMENT_SCHEDULES_ALL APS,

1161: FUNCTION INV_AMT_REMAINING_WOTAX(
1162: p_customer_trx_id IN NUMBER) RETURN NUMBER IS
1163: CURSOR invoice_amount_remaining_csr(p_header_id NUMBER) IS
1164: SELECT SUM(NVL(APS.AMOUNT_DUE_REMAINING,0)) AMOUNT_DUE_REMAINING
1165: FROM AR_PAYMENT_SCHEDULES_ALL APS,
1166: RA_CUSTOMER_TRX_ALL RACTRX
1167: WHERE RACTRX.CUSTOMER_TRX_ID = APS.CUSTOMER_TRX_ID
1168: AND RACTRX.CUSTOMER_TRX_ID = p_header_id;
1169: l_invoice_amount_remaining NUMBER;

Line 1209: ar_payment_schedules_all sch,

1205: p_customer_trx_line_id NUMBER) RETURN NUMBER IS
1206: CURSOR line_credited_csr(p_header_id NUMBER, p_line_id NUMBER) IS
1207: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) credit_applied
1208: FROM ar_receivable_applications_all app,
1209: ar_payment_schedules_all sch,
1210: ar_distributions_all ad
1211: WHERE app.status = 'APP'
1212: AND app.applied_payment_schedule_id = sch.payment_schedule_id
1213: AND sch.class = 'INV'

Line 1236: ar_payment_schedules_all sch,

1232: --dkagrawa modified the cusrsor to add class CM
1233: CURSOR line_applied_csr(p_header_id NUMBER, p_line_id NUMBER) IS
1234: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) line_applied
1235: FROM ar_receivable_applications_all app,
1236: ar_payment_schedules_all sch,
1237: ar_distributions_all ad
1238: WHERE app.status = 'APP'
1239: AND app.applied_payment_schedule_id = sch.payment_schedule_id
1240: AND sch.class IN ('INV','CM') --Receipt can be applied against credit memo

Line 1261: FROM AR_PAYMENT_SCHEDULES_ALL APS,

1257: FUNCTION INVOICE_AMOUNT_ADJUSTED(
1258: p_customer_trx_id IN NUMBER) RETURN NUMBER IS
1259: CURSOR invoice_amount_adj_csr(p_header_id NUMBER) IS
1260: SELECT SUM(NVL(APS.AMOUNT_ADJUSTED,0)) AMOUNT_ADJUSTED
1261: FROM AR_PAYMENT_SCHEDULES_ALL APS,
1262: RA_CUSTOMER_TRX_ALL RACTRX
1263: WHERE RACTRX.CUSTOMER_TRX_ID = APS.CUSTOMER_TRX_ID
1264: AND RACTRX.CUSTOMER_TRX_ID = p_header_id;
1265: l_invoice_amount_adj NUMBER;

Line 1281: ar_payment_schedules_all sch,

1277:
1278: CURSOR invoice_ln_tax_adj(p_header_id NUMBER, p_line_id NUMBER) IS
1279: SELECT SUM(nvl(dist.amount_cr,0))- SUM(nvl(dist.amount_dr,0)) tax_adjusted
1280: FROM ar_adjustments_all adj,
1281: ar_payment_schedules_all sch,
1282: ar_distributions_all dist,
1283: ra_customer_trx_lines_all lines
1284: WHERE adj.payment_schedule_id = sch.payment_schedule_id
1285: AND sch.class = 'INV'

Line 1320: ar_payment_schedules_all aps

1316: CURSOR invoice_ln_amount_adj(p_header_id NUMBER, p_line_id NUMBER) IS
1317: SELECT SUM(nvl(dist.amount_cr,0))- SUM(nvl(dist.amount_dr,0)) amt_adjsuted
1318: FROM ar_distributions_all dist ,
1319: ar_adjustments_all adj ,
1320: ar_payment_schedules_all aps
1321: WHERE dist.source_table = 'ADJ'
1322: AND dist.source_id = adj.adjustment_id
1323: AND aps.customer_trx_id = p_header_id
1324: AND adj.payment_schedule_id = aps.payment_schedule_id

Line 1376: ar_payment_schedules_all sch,

1372:
1373: CURSOR tax_applied_csr(p_header_id NUMBER, p_line_id NUMBER) IS
1374: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) tax_applied
1375: FROM ar_receivable_applications_all app,
1376: ar_payment_schedules_all sch,
1377: ar_distributions_all ad,
1378: ra_customer_trx_lines_all lines
1379: WHERE app.status = 'APP'
1380: AND app.applied_payment_schedule_id = sch.payment_schedule_id

Line 1412: ar_payment_schedules_all sch,

1408:
1409: CURSOR tax_credited_csr(p_header_id NUMBER, p_line_id NUMBER) IS
1410: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) credit_applied
1411: FROM ar_receivable_applications_all app,
1412: ar_payment_schedules_all sch,
1413: ar_distributions_all ad,
1414: ra_customer_trx_lines_all lines
1415: WHERE app.status = 'APP'
1416: AND app.applied_payment_schedule_id = sch.payment_schedule_id

Line 1449: ar_payment_schedules_all sch,

1445:
1446: CURSOR invoice_ln_tax_adj(p_header_id NUMBER, p_line_id NUMBER) IS
1447: SELECT SUM(nvl(dist.amount_cr,0))- SUM(nvl(dist.amount_dr,0)) tax_adjusted
1448: FROM ar_adjustments_all adj,
1449: ar_payment_schedules_all sch,
1450: ar_distributions_all dist,
1451: ra_customer_trx_lines_all lines
1452: WHERE adj.payment_schedule_id = sch.payment_schedule_id
1453: AND sch.class = 'INV'