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.OZF_SETTLEMENT_DOC_PVT dependencies on AR_PAYMENT_SCHEDULES

Line 154: , ar_payment_schedules pay

150: , rec.apply_date
151: , rec.amount_applied
152: , pay.status
153: FROM ar_receivable_applications rec
154: , ar_payment_schedules pay
155: WHERE rec.cash_receipt_id = cv_cash_receipt_id
156: AND rec.applied_payment_schedule_id = pay.payment_schedule_id
157: AND pay.customer_trx_id = cv_customer_trx_id
158: AND rec.display = 'Y';

Line 168: FROM ar_payment_schedules pay

164: , pay.trx_number
165: , pay.trx_date --?? verify
166: , pay.amount_applied
167: , pay.status
168: FROM ar_payment_schedules pay
169: WHERE pay.customer_trx_id = cv_customer_trx_id;
170:
171: -- Chargeback
172: CURSOR csr_chargeback(cv_customer_trx_id IN NUMBER) IS

Line 181: , ar_payment_schedules pay

177: , sum(cust_lines.extended_amount) --"settlement_amount"
178: , pay.status --"status_code"
179: FROM ra_customer_trx cust
180: , ra_customer_trx_lines cust_lines
181: , ar_payment_schedules pay
182: WHERE cust.customer_trx_id = cv_customer_trx_id
183: AND cust.customer_trx_id = pay.customer_trx_id
184: AND cust.customer_trx_id = cust_lines.customer_trx_id
185: AND pay.customer_trx_id = cust_lines.customer_trx_id -- fix for bug 4897546

Line 203: , ar_payment_schedules pay

199: , rec.apply_date
200: , rec.amount_applied
201: , pay.status
202: FROM ar_receivable_applications rec
203: , ar_payment_schedules pay
204: WHERE rec.cash_receipt_id = cv_cash_receipt_id
205: AND rec.applied_payment_schedule_id = pay.payment_schedule_id
206: AND pay.payment_schedule_id = -1
207: AND rec.display='Y'

Line 219: , ar_payment_schedules pay

215: , rec.apply_date
216: , rec.amount_applied
217: , pay.status
218: FROM ar_receivable_applications rec
219: , ar_payment_schedules pay
220: WHERE rec.cash_receipt_id = cv_cash_receipt_id
221: AND rec.applied_payment_schedule_id = pay.payment_schedule_id
222: AND pay.payment_schedule_id = -3
223: AND rec.display='Y'

Line 235: , ar_payment_schedules pay

231: , adj.apply_date --"settlement_date"
232: , adj.amount --"settlement_amount"
233: , pay.status --"status_code"
234: FROM ar_adjustments adj
235: , ar_payment_schedules pay
236: WHERE adj.payment_schedule_id = pay.payment_schedule_id
237: AND adj.adjustment_id = cv_adjust_id;
238:
239: -- Find out claim object version number

Line 253: FROM ar_payment_schedules pay

249: , pay.trx_number
250: , sysdate
251: , (oc.amount_settled * -1)
252: , pay.status
253: FROM ar_payment_schedules pay
254: , ozf_claims oc
255: WHERE pay.customer_trx_id = oc.payment_reference_id
256: AND oc.claim_id = cv_claim_id;
257:

Line 1352: ar_payment_schedules pay

1348: , pay.amount_due_original --"settlement_amount"
1349: , pay.status --"status_code"
1350: FROM ra_customer_trx cust,
1351: ra_customer_trx_lines lines,
1352: ar_payment_schedules pay
1353: where cust.customer_trx_id = lines.customer_trx_id
1354: and cust.customer_trx_id = pay.customer_trx_id
1355: and cust.complete_flag = 'Y'
1356: AND lines.interface_line_attribute2 = cv_claim_id

Line 1367: from ar_payment_schedules pay , ( select distinct customer_trx_id

1363: , pay.cust_trx_type_id --"settlement_type_id"
1364: , pay.trx_number --"settlement_number"
1365: , pay.trx_date --"settlement_date"
1366: , sum(pay.amount_due_original) --"settlement_amount"
1367: from ar_payment_schedules pay , ( select distinct customer_trx_id
1368: from ozf_claim_lines ln , ra_customer_trx_lines cm_line
1369: where cm_line.line_type = 'LINE'
1370: and cm_line.interface_line_context = 'ORDER ENTRY' --added filter for 4940650
1371: and cm_line.interface_line_attribute6 = to_char(ln.payment_reference_id) -- order line id

Line 2240: , ar_payment_schedules pay

2236: , adj.apply_date --"settlement_date"
2237: , adj.amount --"settlement_amount"
2238: , pay.status --"status_code"
2239: FROM ar_adjustments adj
2240: , ar_payment_schedules pay
2241: WHERE adj.payment_schedule_id = pay.payment_schedule_id
2242: AND adj.adjustment_id = cv_adjust_id;
2243:
2244: BEGIN

Line 2405: from ar_payment_schedules ps, ra_customer_trx trx , ( select distinct customer_trx_id

2401: select sum(nvl(amount_line_items_original, 0))
2402: , sum(nvl(tax_original,0))
2403: , sum(nvl(freight_original,0))
2404: , previous_customer_trx_id
2405: from ar_payment_schedules ps, ra_customer_trx trx , ( select distinct customer_trx_id
2406: from ozf_claim_lines ln , ra_customer_trx_lines cm_line
2407: where cm_line.line_type = 'LINE'
2408: and cm_line.interface_line_context = 'ORDER ENTRY' --added filter for 4953844
2409: and cm_line.interface_line_attribute6 = to_char(ln.payment_reference_id)

Line 3385: FROM ar_payment_schedules

3381: CURSOR csr_cm_dm_total_amount(cv_customer_trx_id IN NUMBER) IS
3382: SELECT NVL(SUM(amount_line_items_original), 0)
3383: , NVL(SUM(tax_original), 0)
3384: , NVL(SUM(freight_original), 0)
3385: FROM ar_payment_schedules
3386: WHERE customer_trx_id = cv_customer_trx_id;
3387:
3388: CURSOR csr_sum_line_amount(cv_claim_id IN NUMBER) IS
3389: SELECT SUM(claim_currency_amount)