eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_REVENUE_MANAGEMENT_PVT dependencies on AR_RECEIVABLE_APPLICATIONS

Line 4129: FROM ar_receivable_applications

4125: receivables_charges_applied,
4126: line_applied,
4127: freight_applied,
4128: gl_date
4129: FROM ar_receivable_applications
4130: WHERE receivable_application_id = p_receivable_application_id;
4131:
4132: -- This cursor retrieves the currency information for the
4133: -- given invoice.

Line 4146: | query the details from ar_receivable_applications_all table. and then

4142:
4143: /*------------------------------------------------------------------------
4144: | If this procedure is being called from receipt reversal then
4145: | the only thing we have is the receivable application id. As a result,
4146: | query the details from ar_receivable_applications_all table. and then
4147: | from the ra_customer_trx_all.
4148: | If this is being called from receipt application then simply copy the
4149: | passed variable into the local variables.
4150: +------------------------------------------------------------------------*/

Line 6432: l_acctd_freight_applied ar_receivable_applications.freight_applied%TYPE;

6428: /*-----------------------------------------------------------------------+
6429: | Local Variable Declarations and initializations |
6430: +-----------------------------------------------------------------------*/
6431:
6432: l_acctd_freight_applied ar_receivable_applications.freight_applied%TYPE;
6433: l_acctd_line_applied ar_receivable_applications.line_applied%TYPE;
6434: l_acctd_tax_applied ar_receivable_applications.tax_applied%TYPE;
6435: l_acctd_charges_applied
6436: ar_receivable_applications.receivables_charges_applied%TYPE;

Line 6433: l_acctd_line_applied ar_receivable_applications.line_applied%TYPE;

6429: | Local Variable Declarations and initializations |
6430: +-----------------------------------------------------------------------*/
6431:
6432: l_acctd_freight_applied ar_receivable_applications.freight_applied%TYPE;
6433: l_acctd_line_applied ar_receivable_applications.line_applied%TYPE;
6434: l_acctd_tax_applied ar_receivable_applications.tax_applied%TYPE;
6435: l_acctd_charges_applied
6436: ar_receivable_applications.receivables_charges_applied%TYPE;
6437:

Line 6434: l_acctd_tax_applied ar_receivable_applications.tax_applied%TYPE;

6430: +-----------------------------------------------------------------------*/
6431:
6432: l_acctd_freight_applied ar_receivable_applications.freight_applied%TYPE;
6433: l_acctd_line_applied ar_receivable_applications.line_applied%TYPE;
6434: l_acctd_tax_applied ar_receivable_applications.tax_applied%TYPE;
6435: l_acctd_charges_applied
6436: ar_receivable_applications.receivables_charges_applied%TYPE;
6437:
6438: l_freight_applied ar_receivable_applications.freight_applied%TYPE;

Line 6436: ar_receivable_applications.receivables_charges_applied%TYPE;

6432: l_acctd_freight_applied ar_receivable_applications.freight_applied%TYPE;
6433: l_acctd_line_applied ar_receivable_applications.line_applied%TYPE;
6434: l_acctd_tax_applied ar_receivable_applications.tax_applied%TYPE;
6435: l_acctd_charges_applied
6436: ar_receivable_applications.receivables_charges_applied%TYPE;
6437:
6438: l_freight_applied ar_receivable_applications.freight_applied%TYPE;
6439: l_line_applied ar_receivable_applications.line_applied%TYPE;
6440: l_tax_applied ar_receivable_applications.tax_applied%TYPE;

Line 6438: l_freight_applied ar_receivable_applications.freight_applied%TYPE;

6434: l_acctd_tax_applied ar_receivable_applications.tax_applied%TYPE;
6435: l_acctd_charges_applied
6436: ar_receivable_applications.receivables_charges_applied%TYPE;
6437:
6438: l_freight_applied ar_receivable_applications.freight_applied%TYPE;
6439: l_line_applied ar_receivable_applications.line_applied%TYPE;
6440: l_tax_applied ar_receivable_applications.tax_applied%TYPE;
6441: l_gl_date ar_receivable_applications.gl_date%TYPE;
6442: l_charges_applied

Line 6439: l_line_applied ar_receivable_applications.line_applied%TYPE;

6435: l_acctd_charges_applied
6436: ar_receivable_applications.receivables_charges_applied%TYPE;
6437:
6438: l_freight_applied ar_receivable_applications.freight_applied%TYPE;
6439: l_line_applied ar_receivable_applications.line_applied%TYPE;
6440: l_tax_applied ar_receivable_applications.tax_applied%TYPE;
6441: l_gl_date ar_receivable_applications.gl_date%TYPE;
6442: l_charges_applied
6443: ar_receivable_applications.receivables_charges_applied%TYPE;

Line 6440: l_tax_applied ar_receivable_applications.tax_applied%TYPE;

6436: ar_receivable_applications.receivables_charges_applied%TYPE;
6437:
6438: l_freight_applied ar_receivable_applications.freight_applied%TYPE;
6439: l_line_applied ar_receivable_applications.line_applied%TYPE;
6440: l_tax_applied ar_receivable_applications.tax_applied%TYPE;
6441: l_gl_date ar_receivable_applications.gl_date%TYPE;
6442: l_charges_applied
6443: ar_receivable_applications.receivables_charges_applied%TYPE;
6444: l_acctd_amount_applied

Line 6441: l_gl_date ar_receivable_applications.gl_date%TYPE;

6437:
6438: l_freight_applied ar_receivable_applications.freight_applied%TYPE;
6439: l_line_applied ar_receivable_applications.line_applied%TYPE;
6440: l_tax_applied ar_receivable_applications.tax_applied%TYPE;
6441: l_gl_date ar_receivable_applications.gl_date%TYPE;
6442: l_charges_applied
6443: ar_receivable_applications.receivables_charges_applied%TYPE;
6444: l_acctd_amount_applied
6445: ar_receivable_applications.acctd_amount_applied_to%TYPE;

Line 6443: ar_receivable_applications.receivables_charges_applied%TYPE;

6439: l_line_applied ar_receivable_applications.line_applied%TYPE;
6440: l_tax_applied ar_receivable_applications.tax_applied%TYPE;
6441: l_gl_date ar_receivable_applications.gl_date%TYPE;
6442: l_charges_applied
6443: ar_receivable_applications.receivables_charges_applied%TYPE;
6444: l_acctd_amount_applied
6445: ar_receivable_applications.acctd_amount_applied_to%TYPE;
6446:
6447: ----------------------

Line 6445: ar_receivable_applications.acctd_amount_applied_to%TYPE;

6441: l_gl_date ar_receivable_applications.gl_date%TYPE;
6442: l_charges_applied
6443: ar_receivable_applications.receivables_charges_applied%TYPE;
6444: l_acctd_amount_applied
6445: ar_receivable_applications.acctd_amount_applied_to%TYPE;
6446:
6447: ----------------------
6448: -- rounding related --
6449: ----------------------

Line 7211: FROM ar_receivable_applications ara,

7207: ara.freight_applied,
7208: rct.invoice_currency_code,
7209: rct.exchange_rate,
7210: ara.gl_date
7211: FROM ar_receivable_applications ara,
7212: ra_customer_trx rct
7213: WHERE ara.request_id = p_request_id
7214: AND ara.applied_customer_trx_id = rct.customer_trx_id;
7215: