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.

[Home] [Help]

APPS.ZX_AR_TAX_CLASSIFICATN_DEF_PKG dependencies on RA_CUSTOMER_TRX

Line 88: DET_DATE RA_CUSTOMER_TRX.TRX_DATE%TYPE,

84:
85: TYPE tax_code_rec_type IS RECORD
86: (ORG_ID ZX_LINES.INTERNAL_ORGANIZATION_ID%TYPE,
87: LOOKUP_CODE ZX_RATES_B.TAX_RATE_CODE%TYPE,
88: DET_DATE RA_CUSTOMER_TRX.TRX_DATE%TYPE,
89: TAX_CODE ZX_RATES_B.TAX_RATE_CODE%TYPE
90: );
91:
92: TYPE tax_code_tbl_type IS TABLE OF tax_code_rec_type INDEX BY BINARY_INTEGER;

Line 122: bill_to_cust_id ra_customer_trx.bill_to_customer_id%TYPE,

118: /*-----------------------------------------------------------------------*/
119: /* Transaction Header Data */
120: /*-----------------------------------------------------------------------*/
121:
122: bill_to_cust_id ra_customer_trx.bill_to_customer_id%TYPE,
123: ship_to_cust_id ra_customer_trx.ship_to_customer_id%TYPE,
124:
125: customer_trx_id NUMBER,
126:

Line 123: ship_to_cust_id ra_customer_trx.ship_to_customer_id%TYPE,

119: /* Transaction Header Data */
120: /*-----------------------------------------------------------------------*/
121:
122: bill_to_cust_id ra_customer_trx.bill_to_customer_id%TYPE,
123: ship_to_cust_id ra_customer_trx.ship_to_customer_id%TYPE,
124:
125: customer_trx_id NUMBER,
126:
127: trx_number ra_customer_trx.trx_number%TYPE,

Line 127: trx_number ra_customer_trx.trx_number%TYPE,

123: ship_to_cust_id ra_customer_trx.ship_to_customer_id%TYPE,
124:
125: customer_trx_id NUMBER,
126:
127: trx_number ra_customer_trx.trx_number%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,

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 133: previous_trx_number ra_customer_trx.trx_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,
137: bill_to_site_use_id hz_cust_site_uses.site_use_id%TYPE,

Line 134: trx_date ra_customer_trx.trx_date%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,
137: bill_to_site_use_id hz_cust_site_uses.site_use_id%TYPE,
138: ship_to_postal_code hz_locations.postal_code%TYPE,

Line 142: invoicing_rule_id ra_customer_trx.invoicing_rule_id%TYPE,

138: ship_to_postal_code hz_locations.postal_code%TYPE,
139: bill_to_postal_code hz_locations.postal_code%TYPE,
140: ship_to_location_id NUMBER,
141: bill_to_location_id NUMBER,
142: invoicing_rule_id ra_customer_trx.invoicing_rule_id%TYPE,
143: fob_point ra_customer_trx.fob_point%TYPE,
144: trx_currency_code ra_customer_trx.invoice_currency_code%TYPE,
145: trx_exchange_rate ra_customer_trx.exchange_rate%TYPE,
146: minimum_accountable_unit fnd_currencies.minimum_accountable_unit%TYPE,

Line 143: fob_point ra_customer_trx.fob_point%TYPE,

139: bill_to_postal_code hz_locations.postal_code%TYPE,
140: ship_to_location_id NUMBER,
141: bill_to_location_id NUMBER,
142: invoicing_rule_id ra_customer_trx.invoicing_rule_id%TYPE,
143: fob_point ra_customer_trx.fob_point%TYPE,
144: trx_currency_code ra_customer_trx.invoice_currency_code%TYPE,
145: trx_exchange_rate ra_customer_trx.exchange_rate%TYPE,
146: minimum_accountable_unit fnd_currencies.minimum_accountable_unit%TYPE,
147: precision fnd_currencies.precision%TYPE,

Line 144: trx_currency_code ra_customer_trx.invoice_currency_code%TYPE,

140: ship_to_location_id NUMBER,
141: bill_to_location_id NUMBER,
142: invoicing_rule_id ra_customer_trx.invoicing_rule_id%TYPE,
143: fob_point ra_customer_trx.fob_point%TYPE,
144: trx_currency_code ra_customer_trx.invoice_currency_code%TYPE,
145: trx_exchange_rate ra_customer_trx.exchange_rate%TYPE,
146: minimum_accountable_unit fnd_currencies.minimum_accountable_unit%TYPE,
147: precision fnd_currencies.precision%TYPE,
148: tax_header_level_flag hz_cust_accounts.tax_header_level_flag%TYPE,

Line 145: trx_exchange_rate ra_customer_trx.exchange_rate%TYPE,

141: bill_to_location_id NUMBER,
142: invoicing_rule_id ra_customer_trx.invoicing_rule_id%TYPE,
143: fob_point ra_customer_trx.fob_point%TYPE,
144: trx_currency_code ra_customer_trx.invoice_currency_code%TYPE,
145: trx_exchange_rate ra_customer_trx.exchange_rate%TYPE,
146: minimum_accountable_unit fnd_currencies.minimum_accountable_unit%TYPE,
147: precision fnd_currencies.precision%TYPE,
148: tax_header_level_flag hz_cust_accounts.tax_header_level_flag%TYPE,
149: tax_rounding_rule hz_cust_accounts.tax_rounding_rule%TYPE,

Line 155: payment_term_id ra_customer_trx.term_id%TYPE,

151: /* Release 11 Transaction header data */
152: /*-----------------------------------------------------------------------*/
153: trx_type_id ra_cust_trx_types.cust_trx_type_id%TYPE,
154: ship_from_warehouse_id NUMBER,
155: payment_term_id ra_customer_trx.term_id%TYPE,
156:
157:
158: /*-----------------------------------------------------------------------*/
159: /* Transaction Line Data */

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;