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.ZX_AR_TAX_CLASSIFICATN_DEF_PKG dependencies on RA_CUSTOMER_TRX_LINES

Line 132: previous_customer_trx_id ra_customer_trx_lines.previous_customer_trx_id%TYPE,

128: bill_to_customer_number hz_cust_accounts.account_number%TYPE,
129: ship_to_customer_number hz_cust_accounts.account_number%TYPE,
130: bill_to_customer_name hz_parties.party_name%TYPE,
131: ship_to_customer_name hz_parties.party_name%TYPE,
132: previous_customer_trx_id ra_customer_trx_lines.previous_customer_trx_id%TYPE,
133: previous_trx_number ra_customer_trx.trx_number%TYPE,
134: trx_date ra_customer_trx.trx_date%TYPE,
135: gl_date ra_cust_trx_line_gl_dist.gl_date%TYPE,
136: ship_to_site_use_id hz_cust_site_uses.site_use_id%TYPE,

Line 163: previous_customer_trx_line_id ra_customer_trx_lines.previous_customer_trx_line_id%TYPE,

159: /* Transaction Line Data */
160: /*-----------------------------------------------------------------------*/
161: customer_trx_line_id NUMBER,
162:
163: previous_customer_trx_line_id ra_customer_trx_lines.previous_customer_trx_line_id%TYPE,
164: link_to_cust_trx_line_id ra_customer_trx_lines.link_to_cust_trx_line_id%TYPE,
165: memo_line_id ra_customer_trx_lines.memo_line_id%TYPE,
166: taxed_quantity ra_customer_trx_lines.quantity_invoiced%TYPE,
167: inventory_item_id mtl_system_items.inventory_item_id%TYPE,

Line 164: link_to_cust_trx_line_id ra_customer_trx_lines.link_to_cust_trx_line_id%TYPE,

160: /*-----------------------------------------------------------------------*/
161: customer_trx_line_id NUMBER,
162:
163: previous_customer_trx_line_id ra_customer_trx_lines.previous_customer_trx_line_id%TYPE,
164: link_to_cust_trx_line_id ra_customer_trx_lines.link_to_cust_trx_line_id%TYPE,
165: memo_line_id ra_customer_trx_lines.memo_line_id%TYPE,
166: taxed_quantity ra_customer_trx_lines.quantity_invoiced%TYPE,
167: inventory_item_id mtl_system_items.inventory_item_id%TYPE,
168: extended_amount ra_customer_trx_lines.extended_amount%TYPE,

Line 165: memo_line_id ra_customer_trx_lines.memo_line_id%TYPE,

161: customer_trx_line_id NUMBER,
162:
163: previous_customer_trx_line_id ra_customer_trx_lines.previous_customer_trx_line_id%TYPE,
164: link_to_cust_trx_line_id ra_customer_trx_lines.link_to_cust_trx_line_id%TYPE,
165: memo_line_id ra_customer_trx_lines.memo_line_id%TYPE,
166: taxed_quantity ra_customer_trx_lines.quantity_invoiced%TYPE,
167: inventory_item_id mtl_system_items.inventory_item_id%TYPE,
168: extended_amount ra_customer_trx_lines.extended_amount%TYPE,
169: entered_amount ra_customer_trx_lines.extended_amount%TYPE,

Line 166: taxed_quantity ra_customer_trx_lines.quantity_invoiced%TYPE,

162:
163: previous_customer_trx_line_id ra_customer_trx_lines.previous_customer_trx_line_id%TYPE,
164: link_to_cust_trx_line_id ra_customer_trx_lines.link_to_cust_trx_line_id%TYPE,
165: memo_line_id ra_customer_trx_lines.memo_line_id%TYPE,
166: taxed_quantity ra_customer_trx_lines.quantity_invoiced%TYPE,
167: inventory_item_id mtl_system_items.inventory_item_id%TYPE,
168: extended_amount ra_customer_trx_lines.extended_amount%TYPE,
169: entered_amount ra_customer_trx_lines.extended_amount%TYPE,
170:

Line 168: extended_amount ra_customer_trx_lines.extended_amount%TYPE,

164: link_to_cust_trx_line_id ra_customer_trx_lines.link_to_cust_trx_line_id%TYPE,
165: memo_line_id ra_customer_trx_lines.memo_line_id%TYPE,
166: taxed_quantity ra_customer_trx_lines.quantity_invoiced%TYPE,
167: inventory_item_id mtl_system_items.inventory_item_id%TYPE,
168: extended_amount ra_customer_trx_lines.extended_amount%TYPE,
169: entered_amount ra_customer_trx_lines.extended_amount%TYPE,
170:
171: tax_code ar_vat_tax.tax_code%TYPE,
172: vat_tax_id ar_vat_tax.vat_tax_id%TYPE,

Line 169: entered_amount ra_customer_trx_lines.extended_amount%TYPE,

165: memo_line_id ra_customer_trx_lines.memo_line_id%TYPE,
166: taxed_quantity ra_customer_trx_lines.quantity_invoiced%TYPE,
167: inventory_item_id mtl_system_items.inventory_item_id%TYPE,
168: extended_amount ra_customer_trx_lines.extended_amount%TYPE,
169: entered_amount ra_customer_trx_lines.extended_amount%TYPE,
170:
171: tax_code ar_vat_tax.tax_code%TYPE,
172: vat_tax_id ar_vat_tax.vat_tax_id%TYPE,
173: tax_exemption_id ra_tax_exemptions.tax_exemption_id%TYPE,

Line 177: default_ussgl_transaction_code ra_customer_trx_lines.default_ussgl_transaction_code%TYPE,

173: tax_exemption_id ra_tax_exemptions.tax_exemption_id%TYPE,
174: item_exception_rate_id ra_item_exception_rates.item_exception_rate_id%TYPE,
175: tax_rate ar_vat_tax.tax_rate%TYPE,
176:
177: default_ussgl_transaction_code ra_customer_trx_lines.default_ussgl_transaction_code%TYPE,
178: default_ussgl_trx_code_context ra_customer_trx_lines.default_ussgl_trx_code_context%TYPE,
179: /*-----------------------------------------------------------------------*/
180: /* Release 11 Transaction Line data */
181: /*-----------------------------------------------------------------------*/

Line 178: default_ussgl_trx_code_context ra_customer_trx_lines.default_ussgl_trx_code_context%TYPE,

174: item_exception_rate_id ra_item_exception_rates.item_exception_rate_id%TYPE,
175: tax_rate ar_vat_tax.tax_rate%TYPE,
176:
177: default_ussgl_transaction_code ra_customer_trx_lines.default_ussgl_transaction_code%TYPE,
178: default_ussgl_trx_code_context ra_customer_trx_lines.default_ussgl_trx_code_context%TYPE,
179: /*-----------------------------------------------------------------------*/
180: /* Release 11 Transaction Line data */
181: /*-----------------------------------------------------------------------*/
182: amount_includes_tax_flag CHAR, /* 'Y' if line amount includes tax */

Line 202: tax_control ra_customer_trx_lines.tax_exempt_flag%TYPE,

198: poa_code VARCHAR2(30), /* Point of Order Acceptance */
199:
200: vdrctrl_exempt VARCHAR(30), /* Vendor Control of Tax Exmeptions */
201:
202: tax_control ra_customer_trx_lines.tax_exempt_flag%TYPE,
203: xmpt_cert_no ra_tax_exemptions.customer_exemption_number%TYPE,
204: xmpt_reason ra_tax_exemptions.reason_code%TYPE,
205: xmpt_percent ra_tax_exemptions.percent_exempt%TYPE,
206:

Line 251: tax_line_number ra_customer_trx_lines.line_number%TYPE,

247: tax_type NUMBER, /* Internal flags */
248:
249: sales_tax_id NUMBER,
250: location_segment_id NUMBER,
251: tax_line_number ra_customer_trx_lines.line_number%TYPE,
252: tax_amount ra_customer_trx_lines.extended_amount%TYPE,
253: tax_vendor_return_code ra_customer_trx_lines.tax_vendor_return_code%TYPE,
254: tax_precedence ra_customer_trx_lines.tax_precedence%TYPE,
255: compound_amount NUMBER, /* Amount of Compounded Tax already held in extended_amount */

Line 252: tax_amount ra_customer_trx_lines.extended_amount%TYPE,

248:
249: sales_tax_id NUMBER,
250: location_segment_id NUMBER,
251: tax_line_number ra_customer_trx_lines.line_number%TYPE,
252: tax_amount ra_customer_trx_lines.extended_amount%TYPE,
253: tax_vendor_return_code ra_customer_trx_lines.tax_vendor_return_code%TYPE,
254: tax_precedence ra_customer_trx_lines.tax_precedence%TYPE,
255: compound_amount NUMBER, /* Amount of Compounded Tax already held in extended_amount */
256: effective_tax_rate NUMBER, /* Effective tax rate to be used to calculate tax. */

Line 253: tax_vendor_return_code ra_customer_trx_lines.tax_vendor_return_code%TYPE,

249: sales_tax_id NUMBER,
250: location_segment_id NUMBER,
251: tax_line_number ra_customer_trx_lines.line_number%TYPE,
252: tax_amount ra_customer_trx_lines.extended_amount%TYPE,
253: tax_vendor_return_code ra_customer_trx_lines.tax_vendor_return_code%TYPE,
254: tax_precedence ra_customer_trx_lines.tax_precedence%TYPE,
255: compound_amount NUMBER, /* Amount of Compounded Tax already held in extended_amount */
256: effective_tax_rate NUMBER, /* Effective tax rate to be used to calculate tax. */
257:

Line 254: tax_precedence ra_customer_trx_lines.tax_precedence%TYPE,

250: location_segment_id NUMBER,
251: tax_line_number ra_customer_trx_lines.line_number%TYPE,
252: tax_amount ra_customer_trx_lines.extended_amount%TYPE,
253: tax_vendor_return_code ra_customer_trx_lines.tax_vendor_return_code%TYPE,
254: tax_precedence ra_customer_trx_lines.tax_precedence%TYPE,
255: compound_amount NUMBER, /* Amount of Compounded Tax already held in extended_amount */
256: effective_tax_rate NUMBER, /* Effective tax rate to be used to calculate tax. */
257:
258:

Line 557: TYPE tax_rec_tbl_type is TABLE of RA_CUSTOMER_TRX_LINES%ROWTYPE index by

553: );
554:
555: tax_gbl_rec tax_gbl_rec_type;
556:
557: TYPE tax_rec_tbl_type is TABLE of RA_CUSTOMER_TRX_LINES%ROWTYPE index by
558: binary_integer;
559:
560: TYPE tax_info_rec_tbl_type is TABLE of tax_info_rec_type index by
561: binary_integer;

Line 565: old_line_rec ra_customer_trx_lines%rowtype;

561: binary_integer;
562:
563: tax_rec_tbl tax_rec_tbl_type;
564: tax_info_rec_tbl tax_info_rec_tbl_type;
565: old_line_rec ra_customer_trx_lines%rowtype;
566: new_line_rec ra_customer_trx_lines%rowtype;
567: /*
568: TYPE om_tax_out_rec_type IS RECORD
569: (vat_tax_id ar_vat_tax.vat_tax_id%type,

Line 566: new_line_rec ra_customer_trx_lines%rowtype;

562:
563: tax_rec_tbl tax_rec_tbl_type;
564: tax_info_rec_tbl tax_info_rec_tbl_type;
565: old_line_rec ra_customer_trx_lines%rowtype;
566: new_line_rec ra_customer_trx_lines%rowtype;
567: /*
568: TYPE om_tax_out_rec_type IS RECORD
569: (vat_tax_id ar_vat_tax.vat_tax_id%type,
570: extended_amount ra_customer_trx_lines.extended_amount%TYPE,

Line 570: extended_amount ra_customer_trx_lines.extended_amount%TYPE,

566: new_line_rec ra_customer_trx_lines%rowtype;
567: /*
568: TYPE om_tax_out_rec_type IS RECORD
569: (vat_tax_id ar_vat_tax.vat_tax_id%type,
570: extended_amount ra_customer_trx_lines.extended_amount%TYPE,
571: tax_rate ar_vat_tax.tax_rate%TYPE);*/
572:
573: TYPE om_tax_out_tab_type IS TABLE of tax_info_rec_type index by
574: binary_integer;