APPS.AR_RECEIPT_VAL_PVT dependencies on RA_CUSTOMER_TRX

Line 3539: from ra_customer_trx

3535: ELSIF (p_reference_type = 'CREDIT_MEMO' ) THEN
3536: --
3537: select 'y'
3538: into l_reference_valid
3539: from ra_customer_trx
3540: where customer_trx_id = p_reference_id;
3541: ELSE
3542: --the reference_type is invalid, raise error.
3543: l_ref_type_return_status := FND_API.G_RET_STS_ERROR;

Line 4106: from ra_customer_trx_lines line,

4102: line.customer_trx_line_id LINE_ID,
4103: nvl(line.source_data_key4,0) GROUP_ID ,
4104: nvl(line.amount_due_remaining,0) line_to_apply,
4105: nvl(tax.amount_due_remaining,0) tax_to_apply
4106: from ra_customer_trx_lines line,
4107: (select link_to_cust_trx_line_id,
4108: line_type,
4109: sum(nvl(amount_due_original,0)) amount_due_original,
4110: sum(nvl(amount_due_remaining,0)) amount_due_remaining

Line 4111: from ra_customer_trx_lines

4107: (select link_to_cust_trx_line_id,
4108: line_type,
4109: sum(nvl(amount_due_original,0)) amount_due_original,
4110: sum(nvl(amount_due_remaining,0)) amount_due_remaining
4111: from ra_customer_trx_lines
4112: where customer_trx_id = p_cust_trx_id -- Bug 7241703 Added condition
4113: and nvl(line_type,'TAX') = 'TAX'
4114: group by link_to_cust_trx_line_id,line_type
4115: ) tax

Line 4127: from ra_customer_trx_lines line,

4123: line.customer_trx_line_id line_id,
4124: nvl(line.source_data_key4,0) group_id ,
4125: nvl(line.amount_due_remaining,0) line_to_apply,
4126: nvl(tax.amount_due_remaining,0) tax_to_apply
4127: from ra_customer_trx_lines line,
4128: (select link_to_cust_trx_line_id,
4129: line_type,
4130: sum(nvl(amount_due_original,0)) amount_due_original,
4131: sum(nvl(amount_due_remaining,0)) amount_due_remaining

Line 4132: from ra_customer_trx_lines

4128: (select link_to_cust_trx_line_id,
4129: line_type,
4130: sum(nvl(amount_due_original,0)) amount_due_original,
4131: sum(nvl(amount_due_remaining,0)) amount_due_remaining
4132: from ra_customer_trx_lines
4133: where customer_trx_id = p_cust_trx_id -- Bug 7241703 Added condition
4134: and nvl(line_type,'TAX') = 'TAX'
4135: group by link_to_cust_trx_line_id,line_type
4136: ) tax

Line 4156: l_group_id ra_customer_trx_lines.source_data_key4%type;

4152: llca_ra_rec ar_receivable_applications%rowtype;
4153:
4154: -- LLCA - LINE LEVEL
4155: l_rowid rowid;
4156: l_group_id ra_customer_trx_lines.source_data_key4%type;
4157: l_line_amount_remaining NUMBER;
4158: l_line_tax_remaining NUMBER;
4159: l_line_number NUMBER;
4160: l_calc_tot_amount_app NUMBER;

Line 4556: from ra_customer_trx_lines line,

4552: into
4553: l_group_id,
4554: l_line_amount_remaining,
4555: l_line_tax_remaining
4556: from ra_customer_trx_lines line,
4557: (select link_to_cust_trx_line_id,
4558: line_type,
4559: sum(nvl(amount_due_original,0)) amount_due_original,
4560: sum(nvl(amount_due_remaining,0)) amount_due_remaining

Line 4561: from ra_customer_trx_lines

4557: (select link_to_cust_trx_line_id,
4558: line_type,
4559: sum(nvl(amount_due_original,0)) amount_due_original,
4560: sum(nvl(amount_due_remaining,0)) amount_due_remaining
4561: from ra_customer_trx_lines
4562: where customer_trx_id = sp_lines_row.customer_trx_id -- Bug 7241703 Added condition
4563: and nvl(line_type,'TAX') = 'TAX'
4564: group by link_to_cust_trx_line_id,line_type
4565: ) tax

Line 4723: ra_customer_trx_lines trx_lines

4719: 0 chg_disc,
4720: --
4721: rcv_lines.allocated_receipt_amount
4722: from ar_activity_details rcv_lines,
4723: ra_customer_trx_lines trx_lines
4724: where trx_lines.customer_trx_id = p_cust_trx_id
4725: and rcv_lines.cash_receipt_id = p_cash_rec_id
4726: and nvl(rcv_lines.CURRENT_ACTIVITY_FLAG, 'Y') = 'Y' -- Bug 7241111
4727: and trx_lines.line_type = 'LINE'

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