[Home] [Help]
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
191: AND sch.class IN ('INV','CM') --Receipt can be applied against credit memo
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
227: AND sch.class = 'INV'
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'
1214: AND sch.customer_trx_id = p_header_id
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
1241: AND sch.customer_trx_id = p_header_id
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'
1286: AND sch.customer_trx_id = p_header_id
1314: p_customer_trx_line_id IN NUMBER) RETURN NUMBER IS
1315:
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
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
1381: AND sch.class IN ('INV','CM') --Receipt can be applied against credit memo
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
1417: AND sch.class = 'INV'
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'
1454: AND sch.customer_trx_id = p_header_id