DBA Data[Home] [Help]

APPS.AR_RECEIPT_VAL_PVT dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 4741: ra_customer_trx_lines_all trx_lines

4737: sum(Nvl(rcv_lines.tax_discount,0)) tax_disc,
4738: sum(NVl(rcv_lines.freight_discount,0)) frt_disc,
4739: sum(Nvl(rcv_lines.allocated_receipt_amount,0)) allocated
4740: from ar_Activity_details rcv_lines,
4741: ra_customer_trx_lines_all trx_lines
4742: where trx_lines.customer_trx_id = pf_ct_id
4743: and rcv_lines.cash_receipt_id = pf_cr_id
4744: and nvl(rcv_lines.CURRENT_ACTIVITY_FLAG, 'Y') = 'Y' -- Bug 7241111
4745: and trx_lines.line_type in ('FREIGHT','CHARGES')