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_DISTRIBUTIONS_ALL

Line 187: ar_distributions_all ad,

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

Line 253: ar_distributions_all ad,

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
257: AND sch.class = 'INV'

Line 324: ar_distributions_all ad

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
328: AND sch.customer_trx_id = p_header_id

Line 338: ar_distributions_all ad,

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
342: AND sch.class IN ('CM')

Line 1363: ar_distributions_all ad

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'
1367: AND sch.customer_trx_id = p_header_id

Line 1390: ar_distributions_all ad

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
1394: AND sch.customer_trx_id = p_header_id

Line 1437: ar_distributions_all dist,

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'
1441: AND sch.customer_trx_id = p_header_id

Line 1503: FROM ar_distributions_all dist ,

1499: p_customer_trx_line_id IN NUMBER) RETURN NUMBER IS
1500:
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

Line 1562: ar_distributions_all ad,

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
1566: AND sch.class IN ('INV','CM') --Receipt can be applied against credit memo

Line 1598: ar_distributions_all ad,

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
1602: AND sch.class = 'INV'

Line 1635: ar_distributions_all dist,

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'
1639: AND sch.customer_trx_id = p_header_id