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_PRODUCT_INTEGRATION_PKG dependencies on RA_CUSTOMER_TRX

Line 92: bill_to_cust_id ra_customer_trx.bill_to_customer_id%TYPE,

88: /*-----------------------------------------------------------------------*/
89: /* Transaction Header Data */
90: /*-----------------------------------------------------------------------*/
91:
92: bill_to_cust_id ra_customer_trx.bill_to_customer_id%TYPE,
93: ship_to_cust_id ra_customer_trx.ship_to_customer_id%TYPE,
94:
95: customer_trx_id NUMBER,
96:

Line 93: ship_to_cust_id ra_customer_trx.ship_to_customer_id%TYPE,

89: /* Transaction Header Data */
90: /*-----------------------------------------------------------------------*/
91:
92: bill_to_cust_id ra_customer_trx.bill_to_customer_id%TYPE,
93: ship_to_cust_id ra_customer_trx.ship_to_customer_id%TYPE,
94:
95: customer_trx_id NUMBER,
96:
97: trx_number ra_customer_trx.trx_number%TYPE,

Line 97: trx_number ra_customer_trx.trx_number%TYPE,

93: ship_to_cust_id ra_customer_trx.ship_to_customer_id%TYPE,
94:
95: customer_trx_id NUMBER,
96:
97: trx_number ra_customer_trx.trx_number%TYPE,
98: bill_to_customer_number hz_cust_accounts.account_number%TYPE,
99: ship_to_customer_number hz_cust_accounts.account_number%TYPE,
100: bill_to_customer_name hz_parties.party_name%TYPE,
101: ship_to_customer_name hz_parties.party_name%TYPE,

Line 102: previous_customer_trx_id ra_customer_trx_lines.previous_customer_trx_id%TYPE,

98: bill_to_customer_number hz_cust_accounts.account_number%TYPE,
99: ship_to_customer_number hz_cust_accounts.account_number%TYPE,
100: bill_to_customer_name hz_parties.party_name%TYPE,
101: ship_to_customer_name hz_parties.party_name%TYPE,
102: previous_customer_trx_id ra_customer_trx_lines.previous_customer_trx_id%TYPE,
103: previous_trx_number ra_customer_trx.trx_number%TYPE,
104: trx_date ra_customer_trx.trx_date%TYPE,
105: gl_date ra_cust_trx_line_gl_dist.gl_date%TYPE,
106: ship_to_site_use_id hz_cust_site_uses.site_use_id%TYPE,

Line 103: previous_trx_number ra_customer_trx.trx_number%TYPE,

99: ship_to_customer_number hz_cust_accounts.account_number%TYPE,
100: bill_to_customer_name hz_parties.party_name%TYPE,
101: ship_to_customer_name hz_parties.party_name%TYPE,
102: previous_customer_trx_id ra_customer_trx_lines.previous_customer_trx_id%TYPE,
103: previous_trx_number ra_customer_trx.trx_number%TYPE,
104: trx_date ra_customer_trx.trx_date%TYPE,
105: gl_date ra_cust_trx_line_gl_dist.gl_date%TYPE,
106: ship_to_site_use_id hz_cust_site_uses.site_use_id%TYPE,
107: bill_to_site_use_id hz_cust_site_uses.site_use_id%TYPE,

Line 104: trx_date ra_customer_trx.trx_date%TYPE,

100: bill_to_customer_name hz_parties.party_name%TYPE,
101: ship_to_customer_name hz_parties.party_name%TYPE,
102: previous_customer_trx_id ra_customer_trx_lines.previous_customer_trx_id%TYPE,
103: previous_trx_number ra_customer_trx.trx_number%TYPE,
104: trx_date ra_customer_trx.trx_date%TYPE,
105: gl_date ra_cust_trx_line_gl_dist.gl_date%TYPE,
106: ship_to_site_use_id hz_cust_site_uses.site_use_id%TYPE,
107: bill_to_site_use_id hz_cust_site_uses.site_use_id%TYPE,
108: ship_to_postal_code hz_locations.postal_code%TYPE,

Line 112: invoicing_rule_id ra_customer_trx.invoicing_rule_id%TYPE,

108: ship_to_postal_code hz_locations.postal_code%TYPE,
109: bill_to_postal_code hz_locations.postal_code%TYPE,
110: ship_to_location_id NUMBER,
111: bill_to_location_id NUMBER,
112: invoicing_rule_id ra_customer_trx.invoicing_rule_id%TYPE,
113: fob_point ra_customer_trx.fob_point%TYPE,
114: trx_currency_code ra_customer_trx.invoice_currency_code%TYPE,
115: trx_exchange_rate ra_customer_trx.exchange_rate%TYPE,
116: minimum_accountable_unit fnd_currencies.minimum_accountable_unit%TYPE,

Line 113: fob_point ra_customer_trx.fob_point%TYPE,

109: bill_to_postal_code hz_locations.postal_code%TYPE,
110: ship_to_location_id NUMBER,
111: bill_to_location_id NUMBER,
112: invoicing_rule_id ra_customer_trx.invoicing_rule_id%TYPE,
113: fob_point ra_customer_trx.fob_point%TYPE,
114: trx_currency_code ra_customer_trx.invoice_currency_code%TYPE,
115: trx_exchange_rate ra_customer_trx.exchange_rate%TYPE,
116: minimum_accountable_unit fnd_currencies.minimum_accountable_unit%TYPE,
117: precision fnd_currencies.precision%TYPE,

Line 114: trx_currency_code ra_customer_trx.invoice_currency_code%TYPE,

110: ship_to_location_id NUMBER,
111: bill_to_location_id NUMBER,
112: invoicing_rule_id ra_customer_trx.invoicing_rule_id%TYPE,
113: fob_point ra_customer_trx.fob_point%TYPE,
114: trx_currency_code ra_customer_trx.invoice_currency_code%TYPE,
115: trx_exchange_rate ra_customer_trx.exchange_rate%TYPE,
116: minimum_accountable_unit fnd_currencies.minimum_accountable_unit%TYPE,
117: precision fnd_currencies.precision%TYPE,
118: tax_header_level_flag hz_cust_accounts.tax_header_level_flag%TYPE,

Line 115: trx_exchange_rate ra_customer_trx.exchange_rate%TYPE,

111: bill_to_location_id NUMBER,
112: invoicing_rule_id ra_customer_trx.invoicing_rule_id%TYPE,
113: fob_point ra_customer_trx.fob_point%TYPE,
114: trx_currency_code ra_customer_trx.invoice_currency_code%TYPE,
115: trx_exchange_rate ra_customer_trx.exchange_rate%TYPE,
116: minimum_accountable_unit fnd_currencies.minimum_accountable_unit%TYPE,
117: precision fnd_currencies.precision%TYPE,
118: tax_header_level_flag hz_cust_accounts.tax_header_level_flag%TYPE,
119: tax_rounding_rule hz_cust_accounts.tax_rounding_rule%TYPE,

Line 125: payment_term_id ra_customer_trx.term_id%TYPE,

121: /* Release 11 Transaction header data */
122: /*-----------------------------------------------------------------------*/
123: trx_type_id ra_cust_trx_types.cust_trx_type_id%TYPE,
124: ship_from_warehouse_id NUMBER,
125: payment_term_id ra_customer_trx.term_id%TYPE,
126:
127:
128: /*-----------------------------------------------------------------------*/
129: /* Transaction Line Data */

Line 133: previous_customer_trx_line_id ra_customer_trx_lines.previous_customer_trx_line_id%TYPE,

129: /* Transaction Line Data */
130: /*-----------------------------------------------------------------------*/
131: customer_trx_line_id NUMBER,
132:
133: previous_customer_trx_line_id ra_customer_trx_lines.previous_customer_trx_line_id%TYPE,
134: link_to_cust_trx_line_id ra_customer_trx_lines.link_to_cust_trx_line_id%TYPE,
135: memo_line_id ra_customer_trx_lines.memo_line_id%TYPE,
136: taxed_quantity ra_customer_trx_lines.quantity_invoiced%TYPE,
137: inventory_item_id mtl_system_items.inventory_item_id%TYPE,

Line 134: link_to_cust_trx_line_id ra_customer_trx_lines.link_to_cust_trx_line_id%TYPE,

130: /*-----------------------------------------------------------------------*/
131: customer_trx_line_id NUMBER,
132:
133: previous_customer_trx_line_id ra_customer_trx_lines.previous_customer_trx_line_id%TYPE,
134: link_to_cust_trx_line_id ra_customer_trx_lines.link_to_cust_trx_line_id%TYPE,
135: memo_line_id ra_customer_trx_lines.memo_line_id%TYPE,
136: taxed_quantity ra_customer_trx_lines.quantity_invoiced%TYPE,
137: inventory_item_id mtl_system_items.inventory_item_id%TYPE,
138: extended_amount ra_customer_trx_lines.extended_amount%TYPE,

Line 135: memo_line_id ra_customer_trx_lines.memo_line_id%TYPE,

131: customer_trx_line_id NUMBER,
132:
133: previous_customer_trx_line_id ra_customer_trx_lines.previous_customer_trx_line_id%TYPE,
134: link_to_cust_trx_line_id ra_customer_trx_lines.link_to_cust_trx_line_id%TYPE,
135: memo_line_id ra_customer_trx_lines.memo_line_id%TYPE,
136: taxed_quantity ra_customer_trx_lines.quantity_invoiced%TYPE,
137: inventory_item_id mtl_system_items.inventory_item_id%TYPE,
138: extended_amount ra_customer_trx_lines.extended_amount%TYPE,
139: entered_amount ra_customer_trx_lines.extended_amount%TYPE,

Line 136: taxed_quantity ra_customer_trx_lines.quantity_invoiced%TYPE,

132:
133: previous_customer_trx_line_id ra_customer_trx_lines.previous_customer_trx_line_id%TYPE,
134: link_to_cust_trx_line_id ra_customer_trx_lines.link_to_cust_trx_line_id%TYPE,
135: memo_line_id ra_customer_trx_lines.memo_line_id%TYPE,
136: taxed_quantity ra_customer_trx_lines.quantity_invoiced%TYPE,
137: inventory_item_id mtl_system_items.inventory_item_id%TYPE,
138: extended_amount ra_customer_trx_lines.extended_amount%TYPE,
139: entered_amount ra_customer_trx_lines.extended_amount%TYPE,
140:

Line 138: extended_amount ra_customer_trx_lines.extended_amount%TYPE,

134: link_to_cust_trx_line_id ra_customer_trx_lines.link_to_cust_trx_line_id%TYPE,
135: memo_line_id ra_customer_trx_lines.memo_line_id%TYPE,
136: taxed_quantity ra_customer_trx_lines.quantity_invoiced%TYPE,
137: inventory_item_id mtl_system_items.inventory_item_id%TYPE,
138: extended_amount ra_customer_trx_lines.extended_amount%TYPE,
139: entered_amount ra_customer_trx_lines.extended_amount%TYPE,
140:
141: tax_code ar_vat_tax.tax_code%TYPE,
142: vat_tax_id ar_vat_tax.vat_tax_id%TYPE,

Line 139: entered_amount ra_customer_trx_lines.extended_amount%TYPE,

135: memo_line_id ra_customer_trx_lines.memo_line_id%TYPE,
136: taxed_quantity ra_customer_trx_lines.quantity_invoiced%TYPE,
137: inventory_item_id mtl_system_items.inventory_item_id%TYPE,
138: extended_amount ra_customer_trx_lines.extended_amount%TYPE,
139: entered_amount ra_customer_trx_lines.extended_amount%TYPE,
140:
141: tax_code ar_vat_tax.tax_code%TYPE,
142: vat_tax_id ar_vat_tax.vat_tax_id%TYPE,
143: tax_exemption_id ra_tax_exemptions.tax_exemption_id%TYPE,

Line 147: default_ussgl_transaction_code ra_customer_trx_lines.default_ussgl_transaction_code%TYPE,

143: tax_exemption_id ra_tax_exemptions.tax_exemption_id%TYPE,
144: item_exception_rate_id ra_item_exception_rates.item_exception_rate_id%TYPE,
145: tax_rate ar_vat_tax.tax_rate%TYPE,
146:
147: default_ussgl_transaction_code ra_customer_trx_lines.default_ussgl_transaction_code%TYPE,
148: default_ussgl_trx_code_context ra_customer_trx_lines.default_ussgl_trx_code_context%TYPE,
149: /*-----------------------------------------------------------------------*/
150: /* Release 11 Transaction Line data */
151: /*-----------------------------------------------------------------------*/

Line 148: default_ussgl_trx_code_context ra_customer_trx_lines.default_ussgl_trx_code_context%TYPE,

144: item_exception_rate_id ra_item_exception_rates.item_exception_rate_id%TYPE,
145: tax_rate ar_vat_tax.tax_rate%TYPE,
146:
147: default_ussgl_transaction_code ra_customer_trx_lines.default_ussgl_transaction_code%TYPE,
148: default_ussgl_trx_code_context ra_customer_trx_lines.default_ussgl_trx_code_context%TYPE,
149: /*-----------------------------------------------------------------------*/
150: /* Release 11 Transaction Line data */
151: /*-----------------------------------------------------------------------*/
152: amount_includes_tax_flag CHAR, /* 'Y' if line amount includes tax */

Line 172: tax_control ra_customer_trx_lines.tax_exempt_flag%TYPE,

168: poa_code VARCHAR2(30), /* Point of Order Acceptance */
169:
170: vdrctrl_exempt VARCHAR(30), /* Vendor Control of Tax Exmeptions */
171:
172: tax_control ra_customer_trx_lines.tax_exempt_flag%TYPE,
173: xmpt_cert_no ra_tax_exemptions.customer_exemption_number%TYPE,
174: xmpt_reason ra_tax_exemptions.reason_code%TYPE,
175: xmpt_percent ra_tax_exemptions.percent_exempt%TYPE,
176:

Line 221: tax_line_number ra_customer_trx_lines.line_number%TYPE,

217: tax_type NUMBER, /* Internal flags */
218:
219: sales_tax_id NUMBER,
220: location_segment_id NUMBER,
221: tax_line_number ra_customer_trx_lines.line_number%TYPE,
222: tax_amount ra_customer_trx_lines.extended_amount%TYPE,
223: tax_vendor_return_code ra_customer_trx_lines.tax_vendor_return_code%TYPE,
224: tax_precedence ra_customer_trx_lines.tax_precedence%TYPE,
225: compound_amount NUMBER, /* Amount of Compounded Tax already held in extended_amount */

Line 222: tax_amount ra_customer_trx_lines.extended_amount%TYPE,

218:
219: sales_tax_id NUMBER,
220: location_segment_id NUMBER,
221: tax_line_number ra_customer_trx_lines.line_number%TYPE,
222: tax_amount ra_customer_trx_lines.extended_amount%TYPE,
223: tax_vendor_return_code ra_customer_trx_lines.tax_vendor_return_code%TYPE,
224: tax_precedence ra_customer_trx_lines.tax_precedence%TYPE,
225: compound_amount NUMBER, /* Amount of Compounded Tax already held in extended_amount */
226: effective_tax_rate NUMBER, /* Effective tax rate to be used to calculate tax. */

Line 223: tax_vendor_return_code ra_customer_trx_lines.tax_vendor_return_code%TYPE,

219: sales_tax_id NUMBER,
220: location_segment_id NUMBER,
221: tax_line_number ra_customer_trx_lines.line_number%TYPE,
222: tax_amount ra_customer_trx_lines.extended_amount%TYPE,
223: tax_vendor_return_code ra_customer_trx_lines.tax_vendor_return_code%TYPE,
224: tax_precedence ra_customer_trx_lines.tax_precedence%TYPE,
225: compound_amount NUMBER, /* Amount of Compounded Tax already held in extended_amount */
226: effective_tax_rate NUMBER, /* Effective tax rate to be used to calculate tax. */
227:

Line 224: tax_precedence ra_customer_trx_lines.tax_precedence%TYPE,

220: location_segment_id NUMBER,
221: tax_line_number ra_customer_trx_lines.line_number%TYPE,
222: tax_amount ra_customer_trx_lines.extended_amount%TYPE,
223: tax_vendor_return_code ra_customer_trx_lines.tax_vendor_return_code%TYPE,
224: tax_precedence ra_customer_trx_lines.tax_precedence%TYPE,
225: compound_amount NUMBER, /* Amount of Compounded Tax already held in extended_amount */
226: effective_tax_rate NUMBER, /* Effective tax rate to be used to calculate tax. */
227:
228:

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

536: );
537:
538: tax_gbl_rec tax_gbl_rec_type;
539:
540: TYPE tax_rec_tbl_type is TABLE of RA_CUSTOMER_TRX_LINES%ROWTYPE index by
541: binary_integer;
542:
543: TYPE tax_info_rec_tbl_type is TABLE of tax_info_rec_type index by
544: binary_integer;

Line 549: old_line_rec ra_customer_trx_lines%rowtype;

545:
546: tax_rec_tbl tax_rec_tbl_type;
547: tax_info_rec_tbl tax_info_rec_tbl_type;
548: tax_info_out_rec_tbl tax_info_rec_tbl_type;
549: old_line_rec ra_customer_trx_lines%rowtype;
550: new_line_rec ra_customer_trx_lines%rowtype;
551: /*
552: TYPE om_tax_out_rec_type IS RECORD
553: (vat_tax_id ar_vat_tax.vat_tax_id%type,

Line 550: new_line_rec ra_customer_trx_lines%rowtype;

546: tax_rec_tbl tax_rec_tbl_type;
547: tax_info_rec_tbl tax_info_rec_tbl_type;
548: tax_info_out_rec_tbl tax_info_rec_tbl_type;
549: old_line_rec ra_customer_trx_lines%rowtype;
550: new_line_rec ra_customer_trx_lines%rowtype;
551: /*
552: TYPE om_tax_out_rec_type IS RECORD
553: (vat_tax_id ar_vat_tax.vat_tax_id%type,
554: extended_amount ra_customer_trx_lines.extended_amount%TYPE,

Line 554: extended_amount ra_customer_trx_lines.extended_amount%TYPE,

550: new_line_rec ra_customer_trx_lines%rowtype;
551: /*
552: TYPE om_tax_out_rec_type IS RECORD
553: (vat_tax_id ar_vat_tax.vat_tax_id%type,
554: extended_amount ra_customer_trx_lines.extended_amount%TYPE,
555: tax_rate ar_vat_tax.tax_rate%TYPE);*/
556:
557: TYPE trx_type_tbl_type IS TABLE OF ra_cust_trx_types.type%type index by binary_integer;
558: trx_type_tbl trx_type_tbl_type;