DBA Data[Home] [Help]

APPS.AR_RECEIPT_VAL_PVT dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 4879: ra_customer_trx_lines_all trx_lines

4875: sum(Nvl(rcv_lines.tax_discount,0)) tax_disc,
4876: sum(NVl(rcv_lines.freight_discount,0)) frt_disc,
4877: sum(Nvl(rcv_lines.allocated_receipt_amount,0)) allocated
4878: from ar_Activity_details rcv_lines,
4879: ra_customer_trx_lines_all trx_lines
4880: where trx_lines.customer_trx_id = pf_ct_id
4881: and rcv_lines.cash_receipt_id = pf_cr_id
4882: and nvl(rcv_lines.CURRENT_ACTIVITY_FLAG, 'Y') = 'Y' -- Bug 7241111
4883: and trx_lines.line_type in ('FREIGHT','CHARGES')