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 3989: FROM ar_receivable_applications

3985: receivables_charges_applied,
3986: line_applied,
3987: freight_applied,
3988: gl_date
3989: FROM ar_receivable_applications
3990: WHERE receivable_application_id = p_receivable_application_id;
3991:
3992: -- This cursor retrieves the currency information for the
3993: -- given invoice.

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

4002:
4003: /*------------------------------------------------------------------------
4004: | If this procedure is being called from receipt reversal then
4005: | the only thing we have is the receivable application id. As a result,
4006: | query the details from ar_receivable_applications_all table. and then
4007: | from the ra_customer_trx_all.
4008: | If this is being called from receipt application then simply copy the
4009: | passed variable into the local variables.
4010: +------------------------------------------------------------------------*/

Line 6144: l_acctd_freight_applied ar_receivable_applications.freight_applied%TYPE;

6140: /*-----------------------------------------------------------------------+
6141: | Local Variable Declarations and initializations |
6142: +-----------------------------------------------------------------------*/
6143:
6144: l_acctd_freight_applied ar_receivable_applications.freight_applied%TYPE;
6145: l_acctd_line_applied ar_receivable_applications.line_applied%TYPE;
6146: l_acctd_tax_applied ar_receivable_applications.tax_applied%TYPE;
6147: l_acctd_charges_applied
6148: ar_receivable_applications.receivables_charges_applied%TYPE;

Line 6145: l_acctd_line_applied ar_receivable_applications.line_applied%TYPE;

6141: | Local Variable Declarations and initializations |
6142: +-----------------------------------------------------------------------*/
6143:
6144: l_acctd_freight_applied ar_receivable_applications.freight_applied%TYPE;
6145: l_acctd_line_applied ar_receivable_applications.line_applied%TYPE;
6146: l_acctd_tax_applied ar_receivable_applications.tax_applied%TYPE;
6147: l_acctd_charges_applied
6148: ar_receivable_applications.receivables_charges_applied%TYPE;
6149:

Line 6146: l_acctd_tax_applied ar_receivable_applications.tax_applied%TYPE;

6142: +-----------------------------------------------------------------------*/
6143:
6144: l_acctd_freight_applied ar_receivable_applications.freight_applied%TYPE;
6145: l_acctd_line_applied ar_receivable_applications.line_applied%TYPE;
6146: l_acctd_tax_applied ar_receivable_applications.tax_applied%TYPE;
6147: l_acctd_charges_applied
6148: ar_receivable_applications.receivables_charges_applied%TYPE;
6149:
6150: l_freight_applied ar_receivable_applications.freight_applied%TYPE;

Line 6148: ar_receivable_applications.receivables_charges_applied%TYPE;

6144: l_acctd_freight_applied ar_receivable_applications.freight_applied%TYPE;
6145: l_acctd_line_applied ar_receivable_applications.line_applied%TYPE;
6146: l_acctd_tax_applied ar_receivable_applications.tax_applied%TYPE;
6147: l_acctd_charges_applied
6148: ar_receivable_applications.receivables_charges_applied%TYPE;
6149:
6150: l_freight_applied ar_receivable_applications.freight_applied%TYPE;
6151: l_line_applied ar_receivable_applications.line_applied%TYPE;
6152: l_tax_applied ar_receivable_applications.tax_applied%TYPE;

Line 6150: l_freight_applied ar_receivable_applications.freight_applied%TYPE;

6146: l_acctd_tax_applied ar_receivable_applications.tax_applied%TYPE;
6147: l_acctd_charges_applied
6148: ar_receivable_applications.receivables_charges_applied%TYPE;
6149:
6150: l_freight_applied ar_receivable_applications.freight_applied%TYPE;
6151: l_line_applied ar_receivable_applications.line_applied%TYPE;
6152: l_tax_applied ar_receivable_applications.tax_applied%TYPE;
6153: l_gl_date ar_receivable_applications.gl_date%TYPE;
6154: l_charges_applied

Line 6151: l_line_applied ar_receivable_applications.line_applied%TYPE;

6147: l_acctd_charges_applied
6148: ar_receivable_applications.receivables_charges_applied%TYPE;
6149:
6150: l_freight_applied ar_receivable_applications.freight_applied%TYPE;
6151: l_line_applied ar_receivable_applications.line_applied%TYPE;
6152: l_tax_applied ar_receivable_applications.tax_applied%TYPE;
6153: l_gl_date ar_receivable_applications.gl_date%TYPE;
6154: l_charges_applied
6155: ar_receivable_applications.receivables_charges_applied%TYPE;

Line 6152: l_tax_applied ar_receivable_applications.tax_applied%TYPE;

6148: ar_receivable_applications.receivables_charges_applied%TYPE;
6149:
6150: l_freight_applied ar_receivable_applications.freight_applied%TYPE;
6151: l_line_applied ar_receivable_applications.line_applied%TYPE;
6152: l_tax_applied ar_receivable_applications.tax_applied%TYPE;
6153: l_gl_date ar_receivable_applications.gl_date%TYPE;
6154: l_charges_applied
6155: ar_receivable_applications.receivables_charges_applied%TYPE;
6156: l_acctd_amount_applied

Line 6153: l_gl_date ar_receivable_applications.gl_date%TYPE;

6149:
6150: l_freight_applied ar_receivable_applications.freight_applied%TYPE;
6151: l_line_applied ar_receivable_applications.line_applied%TYPE;
6152: l_tax_applied ar_receivable_applications.tax_applied%TYPE;
6153: l_gl_date ar_receivable_applications.gl_date%TYPE;
6154: l_charges_applied
6155: ar_receivable_applications.receivables_charges_applied%TYPE;
6156: l_acctd_amount_applied
6157: ar_receivable_applications.acctd_amount_applied_to%TYPE;

Line 6155: ar_receivable_applications.receivables_charges_applied%TYPE;

6151: l_line_applied ar_receivable_applications.line_applied%TYPE;
6152: l_tax_applied ar_receivable_applications.tax_applied%TYPE;
6153: l_gl_date ar_receivable_applications.gl_date%TYPE;
6154: l_charges_applied
6155: ar_receivable_applications.receivables_charges_applied%TYPE;
6156: l_acctd_amount_applied
6157: ar_receivable_applications.acctd_amount_applied_to%TYPE;
6158:
6159: ----------------------

Line 6157: ar_receivable_applications.acctd_amount_applied_to%TYPE;

6153: l_gl_date ar_receivable_applications.gl_date%TYPE;
6154: l_charges_applied
6155: ar_receivable_applications.receivables_charges_applied%TYPE;
6156: l_acctd_amount_applied
6157: ar_receivable_applications.acctd_amount_applied_to%TYPE;
6158:
6159: ----------------------
6160: -- rounding related --
6161: ----------------------

Line 6837: FROM ar_receivable_applications ara,

6833: ara.freight_applied,
6834: rct.invoice_currency_code,
6835: rct.exchange_rate,
6836: ara.gl_date
6837: FROM ar_receivable_applications ara,
6838: ra_customer_trx rct
6839: WHERE ara.request_id = p_request_id
6840: AND ara.applied_customer_trx_id = rct.customer_trx_id;
6841: