APPS.AR_RECEIPT_VAL_PVT dependencies on RA_CUSTOMER_TRX_LINES

Line 4244: from ra_customer_trx_lines line,

4240: line.customer_trx_line_id LINE_ID,
4241: nvl(line.source_data_key4,0) GROUP_ID ,
4242: nvl(line.amount_due_remaining,0) line_to_apply,
4243: nvl(tax.amount_due_remaining,0) tax_to_apply
4244: from ra_customer_trx_lines line,
4245: (select link_to_cust_trx_line_id,
4246: line_type,
4247: sum(nvl(amount_due_original,0)) amount_due_original,
4248: sum(nvl(amount_due_remaining,0)) amount_due_remaining

Line 4249: from ra_customer_trx_lines

4245: (select link_to_cust_trx_line_id,
4246: line_type,
4247: sum(nvl(amount_due_original,0)) amount_due_original,
4248: sum(nvl(amount_due_remaining,0)) amount_due_remaining
4249: from ra_customer_trx_lines
4250: where customer_trx_id = p_cust_trx_id -- Bug 7241703 Added condition
4251: and nvl(line_type,'TAX') = 'TAX'
4252: group by link_to_cust_trx_line_id,line_type
4253: ) tax

Line 4265: from ra_customer_trx_lines line,

4261: line.customer_trx_line_id line_id,
4262: nvl(line.source_data_key4,0) group_id ,
4263: nvl(line.amount_due_remaining,0) line_to_apply,
4264: nvl(tax.amount_due_remaining,0) tax_to_apply
4265: from ra_customer_trx_lines line,
4266: (select link_to_cust_trx_line_id,
4267: line_type,
4268: sum(nvl(amount_due_original,0)) amount_due_original,
4269: sum(nvl(amount_due_remaining,0)) amount_due_remaining

Line 4270: from ra_customer_trx_lines

4266: (select link_to_cust_trx_line_id,
4267: line_type,
4268: sum(nvl(amount_due_original,0)) amount_due_original,
4269: sum(nvl(amount_due_remaining,0)) amount_due_remaining
4270: from ra_customer_trx_lines
4271: where customer_trx_id = p_cust_trx_id -- Bug 7241703 Added condition
4272: and nvl(line_type,'TAX') = 'TAX'
4273: group by link_to_cust_trx_line_id,line_type
4274: ) tax

Line 4294: l_group_id ra_customer_trx_lines.source_data_key4%type;

4290: llca_ra_rec ar_receivable_applications%rowtype;
4291:
4292: -- LLCA - LINE LEVEL
4293: l_rowid rowid;
4294: l_group_id ra_customer_trx_lines.source_data_key4%type;
4295: l_line_amount_remaining NUMBER;
4296: l_line_tax_remaining NUMBER;
4297: l_line_number NUMBER;
4298: l_calc_tot_amount_app NUMBER;

Line 4694: from ra_customer_trx_lines line,

4690: into
4691: l_group_id,
4692: l_line_amount_remaining,
4693: l_line_tax_remaining
4694: from ra_customer_trx_lines line,
4695: (select link_to_cust_trx_line_id,
4696: line_type,
4697: sum(nvl(amount_due_original,0)) amount_due_original,
4698: sum(nvl(amount_due_remaining,0)) amount_due_remaining

Line 4699: from ra_customer_trx_lines

4695: (select link_to_cust_trx_line_id,
4696: line_type,
4697: sum(nvl(amount_due_original,0)) amount_due_original,
4698: sum(nvl(amount_due_remaining,0)) amount_due_remaining
4699: from ra_customer_trx_lines
4700: where customer_trx_id = sp_lines_row.customer_trx_id -- Bug 7241703 Added condition
4701: and nvl(line_type,'TAX') = 'TAX'
4702: group by link_to_cust_trx_line_id,line_type
4703: ) tax

Line 4861: ra_customer_trx_lines trx_lines

4857: 0 chg_disc,
4858: --
4859: rcv_lines.allocated_receipt_amount
4860: from ar_activity_details rcv_lines,
4861: ra_customer_trx_lines trx_lines
4862: where trx_lines.customer_trx_id = p_cust_trx_id
4863: and rcv_lines.cash_receipt_id = p_cash_rec_id
4864: and nvl(rcv_lines.CURRENT_ACTIVITY_FLAG, 'Y') = 'Y' -- Bug 7241111
4865: and trx_lines.line_type = 'LINE'

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')