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

Line 112: bill_to_cust_id ra_customer_trx.bill_to_customer_id%TYPE,

108: /*-----------------------------------------------------------------------*/
109: /* Transaction Header Data */
110: /*-----------------------------------------------------------------------*/
111:
112: bill_to_cust_id ra_customer_trx.bill_to_customer_id%TYPE,
113: ship_to_cust_id ra_customer_trx.ship_to_customer_id%TYPE,
114:
115: customer_trx_id NUMBER,
116:

Line 113: ship_to_cust_id ra_customer_trx.ship_to_customer_id%TYPE,

109: /* Transaction Header Data */
110: /*-----------------------------------------------------------------------*/
111:
112: bill_to_cust_id ra_customer_trx.bill_to_customer_id%TYPE,
113: ship_to_cust_id ra_customer_trx.ship_to_customer_id%TYPE,
114:
115: customer_trx_id NUMBER,
116:
117: trx_number ra_customer_trx.trx_number%TYPE,

Line 117: trx_number ra_customer_trx.trx_number%TYPE,

113: ship_to_cust_id ra_customer_trx.ship_to_customer_id%TYPE,
114:
115: customer_trx_id NUMBER,
116:
117: trx_number ra_customer_trx.trx_number%TYPE,
118: bill_to_customer_number hz_cust_accounts.account_number%TYPE,
119: ship_to_customer_number hz_cust_accounts.account_number%TYPE,
120: bill_to_customer_name hz_parties.party_name%TYPE,
121: ship_to_customer_name hz_parties.party_name%TYPE,

Line 122: previous_customer_trx_id ra_customer_trx_lines.previous_customer_trx_id%TYPE,

118: bill_to_customer_number hz_cust_accounts.account_number%TYPE,
119: ship_to_customer_number hz_cust_accounts.account_number%TYPE,
120: bill_to_customer_name hz_parties.party_name%TYPE,
121: ship_to_customer_name hz_parties.party_name%TYPE,
122: previous_customer_trx_id ra_customer_trx_lines.previous_customer_trx_id%TYPE,
123: previous_trx_number ra_customer_trx.trx_number%TYPE,
124: trx_date ra_customer_trx.trx_date%TYPE,
125: gl_date ra_cust_trx_line_gl_dist.gl_date%TYPE,
126: ship_to_site_use_id hz_cust_site_uses.site_use_id%TYPE,

Line 123: previous_trx_number ra_customer_trx.trx_number%TYPE,

119: ship_to_customer_number hz_cust_accounts.account_number%TYPE,
120: bill_to_customer_name hz_parties.party_name%TYPE,
121: ship_to_customer_name hz_parties.party_name%TYPE,
122: previous_customer_trx_id ra_customer_trx_lines.previous_customer_trx_id%TYPE,
123: previous_trx_number ra_customer_trx.trx_number%TYPE,
124: trx_date ra_customer_trx.trx_date%TYPE,
125: gl_date ra_cust_trx_line_gl_dist.gl_date%TYPE,
126: ship_to_site_use_id hz_cust_site_uses.site_use_id%TYPE,
127: bill_to_site_use_id hz_cust_site_uses.site_use_id%TYPE,

Line 124: trx_date ra_customer_trx.trx_date%TYPE,

120: bill_to_customer_name hz_parties.party_name%TYPE,
121: ship_to_customer_name hz_parties.party_name%TYPE,
122: previous_customer_trx_id ra_customer_trx_lines.previous_customer_trx_id%TYPE,
123: previous_trx_number ra_customer_trx.trx_number%TYPE,
124: trx_date ra_customer_trx.trx_date%TYPE,
125: gl_date ra_cust_trx_line_gl_dist.gl_date%TYPE,
126: ship_to_site_use_id hz_cust_site_uses.site_use_id%TYPE,
127: bill_to_site_use_id hz_cust_site_uses.site_use_id%TYPE,
128: ship_to_postal_code hz_locations.postal_code%TYPE,

Line 132: invoicing_rule_id ra_customer_trx.invoicing_rule_id%TYPE,

128: ship_to_postal_code hz_locations.postal_code%TYPE,
129: bill_to_postal_code hz_locations.postal_code%TYPE,
130: ship_to_location_id NUMBER,
131: bill_to_location_id NUMBER,
132: invoicing_rule_id ra_customer_trx.invoicing_rule_id%TYPE,
133: fob_point ra_customer_trx.fob_point%TYPE,
134: trx_currency_code ra_customer_trx.invoice_currency_code%TYPE,
135: trx_exchange_rate ra_customer_trx.exchange_rate%TYPE,
136: minimum_accountable_unit fnd_currencies.minimum_accountable_unit%TYPE,

Line 133: fob_point ra_customer_trx.fob_point%TYPE,

129: bill_to_postal_code hz_locations.postal_code%TYPE,
130: ship_to_location_id NUMBER,
131: bill_to_location_id NUMBER,
132: invoicing_rule_id ra_customer_trx.invoicing_rule_id%TYPE,
133: fob_point ra_customer_trx.fob_point%TYPE,
134: trx_currency_code ra_customer_trx.invoice_currency_code%TYPE,
135: trx_exchange_rate ra_customer_trx.exchange_rate%TYPE,
136: minimum_accountable_unit fnd_currencies.minimum_accountable_unit%TYPE,
137: precision fnd_currencies.precision%TYPE,

Line 134: trx_currency_code ra_customer_trx.invoice_currency_code%TYPE,

130: ship_to_location_id NUMBER,
131: bill_to_location_id NUMBER,
132: invoicing_rule_id ra_customer_trx.invoicing_rule_id%TYPE,
133: fob_point ra_customer_trx.fob_point%TYPE,
134: trx_currency_code ra_customer_trx.invoice_currency_code%TYPE,
135: trx_exchange_rate ra_customer_trx.exchange_rate%TYPE,
136: minimum_accountable_unit fnd_currencies.minimum_accountable_unit%TYPE,
137: precision fnd_currencies.precision%TYPE,
138: tax_header_level_flag hz_cust_accounts.tax_header_level_flag%TYPE,

Line 135: trx_exchange_rate ra_customer_trx.exchange_rate%TYPE,

131: bill_to_location_id NUMBER,
132: invoicing_rule_id ra_customer_trx.invoicing_rule_id%TYPE,
133: fob_point ra_customer_trx.fob_point%TYPE,
134: trx_currency_code ra_customer_trx.invoice_currency_code%TYPE,
135: trx_exchange_rate ra_customer_trx.exchange_rate%TYPE,
136: minimum_accountable_unit fnd_currencies.minimum_accountable_unit%TYPE,
137: precision fnd_currencies.precision%TYPE,
138: tax_header_level_flag hz_cust_accounts.tax_header_level_flag%TYPE,
139: tax_rounding_rule hz_cust_accounts.tax_rounding_rule%TYPE,

Line 145: payment_term_id ra_customer_trx.term_id%TYPE,

141: /* Release 11 Transaction header data */
142: /*-----------------------------------------------------------------------*/
143: trx_type_id ra_cust_trx_types.cust_trx_type_id%TYPE,
144: ship_from_warehouse_id NUMBER,
145: payment_term_id ra_customer_trx.term_id%TYPE,
146:
147:
148: /*-----------------------------------------------------------------------*/
149: /* Transaction Line Data */

Line 153: previous_customer_trx_line_id ra_customer_trx_lines.previous_customer_trx_line_id%TYPE,

149: /* Transaction Line Data */
150: /*-----------------------------------------------------------------------*/
151: customer_trx_line_id NUMBER,
152:
153: previous_customer_trx_line_id ra_customer_trx_lines.previous_customer_trx_line_id%TYPE,
154: link_to_cust_trx_line_id ra_customer_trx_lines.link_to_cust_trx_line_id%TYPE,
155: memo_line_id ra_customer_trx_lines.memo_line_id%TYPE,
156: taxed_quantity ra_customer_trx_lines.quantity_invoiced%TYPE,
157: inventory_item_id mtl_system_items.inventory_item_id%TYPE,

Line 154: link_to_cust_trx_line_id ra_customer_trx_lines.link_to_cust_trx_line_id%TYPE,

150: /*-----------------------------------------------------------------------*/
151: customer_trx_line_id NUMBER,
152:
153: previous_customer_trx_line_id ra_customer_trx_lines.previous_customer_trx_line_id%TYPE,
154: link_to_cust_trx_line_id ra_customer_trx_lines.link_to_cust_trx_line_id%TYPE,
155: memo_line_id ra_customer_trx_lines.memo_line_id%TYPE,
156: taxed_quantity ra_customer_trx_lines.quantity_invoiced%TYPE,
157: inventory_item_id mtl_system_items.inventory_item_id%TYPE,
158: extended_amount ra_customer_trx_lines.extended_amount%TYPE,

Line 155: memo_line_id ra_customer_trx_lines.memo_line_id%TYPE,

151: customer_trx_line_id NUMBER,
152:
153: previous_customer_trx_line_id ra_customer_trx_lines.previous_customer_trx_line_id%TYPE,
154: link_to_cust_trx_line_id ra_customer_trx_lines.link_to_cust_trx_line_id%TYPE,
155: memo_line_id ra_customer_trx_lines.memo_line_id%TYPE,
156: taxed_quantity ra_customer_trx_lines.quantity_invoiced%TYPE,
157: inventory_item_id mtl_system_items.inventory_item_id%TYPE,
158: extended_amount ra_customer_trx_lines.extended_amount%TYPE,
159: entered_amount ra_customer_trx_lines.extended_amount%TYPE,

Line 156: taxed_quantity ra_customer_trx_lines.quantity_invoiced%TYPE,

152:
153: previous_customer_trx_line_id ra_customer_trx_lines.previous_customer_trx_line_id%TYPE,
154: link_to_cust_trx_line_id ra_customer_trx_lines.link_to_cust_trx_line_id%TYPE,
155: memo_line_id ra_customer_trx_lines.memo_line_id%TYPE,
156: taxed_quantity ra_customer_trx_lines.quantity_invoiced%TYPE,
157: inventory_item_id mtl_system_items.inventory_item_id%TYPE,
158: extended_amount ra_customer_trx_lines.extended_amount%TYPE,
159: entered_amount ra_customer_trx_lines.extended_amount%TYPE,
160:

Line 158: extended_amount ra_customer_trx_lines.extended_amount%TYPE,

154: link_to_cust_trx_line_id ra_customer_trx_lines.link_to_cust_trx_line_id%TYPE,
155: memo_line_id ra_customer_trx_lines.memo_line_id%TYPE,
156: taxed_quantity ra_customer_trx_lines.quantity_invoiced%TYPE,
157: inventory_item_id mtl_system_items.inventory_item_id%TYPE,
158: extended_amount ra_customer_trx_lines.extended_amount%TYPE,
159: entered_amount ra_customer_trx_lines.extended_amount%TYPE,
160:
161: tax_code ar_vat_tax.tax_code%TYPE,
162: vat_tax_id ar_vat_tax.vat_tax_id%TYPE,

Line 159: entered_amount ra_customer_trx_lines.extended_amount%TYPE,

155: memo_line_id ra_customer_trx_lines.memo_line_id%TYPE,
156: taxed_quantity ra_customer_trx_lines.quantity_invoiced%TYPE,
157: inventory_item_id mtl_system_items.inventory_item_id%TYPE,
158: extended_amount ra_customer_trx_lines.extended_amount%TYPE,
159: entered_amount ra_customer_trx_lines.extended_amount%TYPE,
160:
161: tax_code ar_vat_tax.tax_code%TYPE,
162: vat_tax_id ar_vat_tax.vat_tax_id%TYPE,
163: tax_exemption_id ra_tax_exemptions.tax_exemption_id%TYPE,

Line 167: default_ussgl_transaction_code ra_customer_trx_lines.default_ussgl_transaction_code%TYPE,

163: tax_exemption_id ra_tax_exemptions.tax_exemption_id%TYPE,
164: item_exception_rate_id ra_item_exception_rates.item_exception_rate_id%TYPE,
165: tax_rate ar_vat_tax.tax_rate%TYPE,
166:
167: default_ussgl_transaction_code ra_customer_trx_lines.default_ussgl_transaction_code%TYPE,
168: default_ussgl_trx_code_context ra_customer_trx_lines.default_ussgl_trx_code_context%TYPE,
169: /*-----------------------------------------------------------------------*/
170: /* Release 11 Transaction Line data */
171: /*-----------------------------------------------------------------------*/

Line 168: default_ussgl_trx_code_context ra_customer_trx_lines.default_ussgl_trx_code_context%TYPE,

164: item_exception_rate_id ra_item_exception_rates.item_exception_rate_id%TYPE,
165: tax_rate ar_vat_tax.tax_rate%TYPE,
166:
167: default_ussgl_transaction_code ra_customer_trx_lines.default_ussgl_transaction_code%TYPE,
168: default_ussgl_trx_code_context ra_customer_trx_lines.default_ussgl_trx_code_context%TYPE,
169: /*-----------------------------------------------------------------------*/
170: /* Release 11 Transaction Line data */
171: /*-----------------------------------------------------------------------*/
172: amount_includes_tax_flag CHAR, /* 'Y' if line amount includes tax */

Line 192: tax_control ra_customer_trx_lines.tax_exempt_flag%TYPE,

188: poa_code VARCHAR2(30), /* Point of Order Acceptance */
189:
190: vdrctrl_exempt VARCHAR(30), /* Vendor Control of Tax Exmeptions */
191:
192: tax_control ra_customer_trx_lines.tax_exempt_flag%TYPE,
193: xmpt_cert_no ra_tax_exemptions.customer_exemption_number%TYPE,
194: xmpt_reason ra_tax_exemptions.reason_code%TYPE,
195: xmpt_percent ra_tax_exemptions.percent_exempt%TYPE,
196:

Line 241: tax_line_number ra_customer_trx_lines.line_number%TYPE,

237: tax_type NUMBER, /* Internal flags */
238:
239: sales_tax_id NUMBER,
240: location_segment_id NUMBER,
241: tax_line_number ra_customer_trx_lines.line_number%TYPE,
242: tax_amount ra_customer_trx_lines.extended_amount%TYPE,
243: tax_vendor_return_code ra_customer_trx_lines.tax_vendor_return_code%TYPE,
244: tax_precedence ra_customer_trx_lines.tax_precedence%TYPE,
245: compound_amount NUMBER, /* Amount of Compounded Tax already held in extended_amount */

Line 242: tax_amount ra_customer_trx_lines.extended_amount%TYPE,

238:
239: sales_tax_id NUMBER,
240: location_segment_id NUMBER,
241: tax_line_number ra_customer_trx_lines.line_number%TYPE,
242: tax_amount ra_customer_trx_lines.extended_amount%TYPE,
243: tax_vendor_return_code ra_customer_trx_lines.tax_vendor_return_code%TYPE,
244: tax_precedence ra_customer_trx_lines.tax_precedence%TYPE,
245: compound_amount NUMBER, /* Amount of Compounded Tax already held in extended_amount */
246: effective_tax_rate NUMBER, /* Effective tax rate to be used to calculate tax. */

Line 243: tax_vendor_return_code ra_customer_trx_lines.tax_vendor_return_code%TYPE,

239: sales_tax_id NUMBER,
240: location_segment_id NUMBER,
241: tax_line_number ra_customer_trx_lines.line_number%TYPE,
242: tax_amount ra_customer_trx_lines.extended_amount%TYPE,
243: tax_vendor_return_code ra_customer_trx_lines.tax_vendor_return_code%TYPE,
244: tax_precedence ra_customer_trx_lines.tax_precedence%TYPE,
245: compound_amount NUMBER, /* Amount of Compounded Tax already held in extended_amount */
246: effective_tax_rate NUMBER, /* Effective tax rate to be used to calculate tax. */
247:

Line 244: tax_precedence ra_customer_trx_lines.tax_precedence%TYPE,

240: location_segment_id NUMBER,
241: tax_line_number ra_customer_trx_lines.line_number%TYPE,
242: tax_amount ra_customer_trx_lines.extended_amount%TYPE,
243: tax_vendor_return_code ra_customer_trx_lines.tax_vendor_return_code%TYPE,
244: tax_precedence ra_customer_trx_lines.tax_precedence%TYPE,
245: compound_amount NUMBER, /* Amount of Compounded Tax already held in extended_amount */
246: effective_tax_rate NUMBER, /* Effective tax rate to be used to calculate tax. */
247:
248:

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

543: );
544:
545: tax_gbl_rec tax_gbl_rec_type;
546:
547: TYPE tax_rec_tbl_type is TABLE of RA_CUSTOMER_TRX_LINES%ROWTYPE index by
548: binary_integer;
549:
550: TYPE tax_info_rec_tbl_type is TABLE of tax_info_rec_type index by
551: binary_integer;

Line 555: old_line_rec ra_customer_trx_lines%rowtype;

551: binary_integer;
552:
553: tax_rec_tbl tax_rec_tbl_type;
554: tax_info_rec_tbl tax_info_rec_tbl_type;
555: old_line_rec ra_customer_trx_lines%rowtype;
556: new_line_rec ra_customer_trx_lines%rowtype;
557: /*
558: TYPE om_tax_out_rec_type IS RECORD
559: (vat_tax_id ar_vat_tax.vat_tax_id%type,

Line 556: new_line_rec ra_customer_trx_lines%rowtype;

552:
553: tax_rec_tbl tax_rec_tbl_type;
554: tax_info_rec_tbl tax_info_rec_tbl_type;
555: old_line_rec ra_customer_trx_lines%rowtype;
556: new_line_rec ra_customer_trx_lines%rowtype;
557: /*
558: TYPE om_tax_out_rec_type IS RECORD
559: (vat_tax_id ar_vat_tax.vat_tax_id%type,
560: extended_amount ra_customer_trx_lines.extended_amount%TYPE,

Line 560: extended_amount ra_customer_trx_lines.extended_amount%TYPE,

556: new_line_rec ra_customer_trx_lines%rowtype;
557: /*
558: TYPE om_tax_out_rec_type IS RECORD
559: (vat_tax_id ar_vat_tax.vat_tax_id%type,
560: extended_amount ra_customer_trx_lines.extended_amount%TYPE,
561: tax_rate ar_vat_tax.tax_rate%TYPE);*/
562:
563: TYPE om_tax_out_tab_type IS TABLE of tax_info_rec_type index by
564: binary_integer;