[Home] [Help]
176: , cust.trx_date --"settlement_date"
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
1347: , cust.trx_date --"settlement_date"
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'
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
1372: and ln.claim_id = cv_claim_id) cla
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)
2410: and ln.claim_id = cv_claim_id) cla