[Home] [Help]
323: , cust.trx_date --"settlement_date"
324: , sum(cust_lines.extended_amount) --"settlement_amount"
325: , pay.status --"status_code"
326: FROM ra_customer_trx cust
327: , ra_customer_trx_lines cust_lines
328: , ar_payment_schedules pay
329: WHERE cust.customer_trx_id = cv_customer_trx_id
330: AND cust.customer_trx_id = pay.customer_trx_id
331: AND cust.customer_trx_id = cust_lines.customer_trx_id
1624: , cust.trx_date --"settlement_date"
1625: , pay.amount_due_original --"settlement_amount"
1626: , pay.status --"status_code"
1627: FROM ra_customer_trx cust,
1628: ra_customer_trx_lines lines,
1629: ar_payment_schedules pay
1630: where cust.customer_trx_id = lines.customer_trx_id
1631: and cust.customer_trx_id = pay.customer_trx_id
1632: and cust.complete_flag = 'Y'
1641: , pay.trx_number --"settlement_number"
1642: , pay.trx_date --"settlement_date"
1643: , sum(pay.amount_due_original) --"settlement_amount"
1644: from ar_payment_schedules pay , ( select distinct customer_trx_id
1645: from ozf_claim_lines ln , ra_customer_trx_lines cm_line
1646: where cm_line.line_type = 'LINE'
1647: and cm_line.interface_line_context = 'ORDER ENTRY' --added filter for 4940650
1648: and cm_line.interface_line_attribute6 = to_char(ln.payment_reference_id) -- order line id
1649: and ln.claim_id = cv_claim_id) cla
2874: , sum(nvl(tax_original,0))
2875: , sum(nvl(freight_original,0))
2876: , previous_customer_trx_id
2877: from ar_payment_schedules ps, ra_customer_trx trx , ( select distinct customer_trx_id
2878: from ozf_claim_lines ln , ra_customer_trx_lines cm_line
2879: where cm_line.line_type = 'LINE'
2880: and cm_line.interface_line_context = 'ORDER ENTRY' --added filter for 4953844
2881: and cm_line.interface_line_attribute6 = to_char(ln.payment_reference_id)
2882: and ln.claim_id = cv_claim_id) cla