136: ,gl_date_from ra_cust_trx_line_gl_dist_all.gl_date%TYPE
137: ,gl_date_to ra_cust_trx_line_gl_dist_all.gl_date%TYPE
138: ,trx_batch_from ra_batches_all.NAME%TYPE
139: ,trx_batch_to ra_batches_all.NAME%TYPE
140: ,trx_number_from ra_customer_trx_all.trx_number%TYPE
141: ,trx_number_to ra_customer_trx_all.trx_number%TYPE
142: ,trx_date_from ra_customer_trx_all.trx_date%TYPE
143: ,trx_date_to ra_customer_trx_all.trx_date%TYPE
144: ,doc_num_from ra_customer_trx_all.doc_sequence_value%TYPE
137: ,gl_date_to ra_cust_trx_line_gl_dist_all.gl_date%TYPE
138: ,trx_batch_from ra_batches_all.NAME%TYPE
139: ,trx_batch_to ra_batches_all.NAME%TYPE
140: ,trx_number_from ra_customer_trx_all.trx_number%TYPE
141: ,trx_number_to ra_customer_trx_all.trx_number%TYPE
142: ,trx_date_from ra_customer_trx_all.trx_date%TYPE
143: ,trx_date_to ra_customer_trx_all.trx_date%TYPE
144: ,doc_num_from ra_customer_trx_all.doc_sequence_value%TYPE
145: ,doc_num_to ra_customer_trx_all.doc_sequence_value%TYPE);
138: ,trx_batch_from ra_batches_all.NAME%TYPE
139: ,trx_batch_to ra_batches_all.NAME%TYPE
140: ,trx_number_from ra_customer_trx_all.trx_number%TYPE
141: ,trx_number_to ra_customer_trx_all.trx_number%TYPE
142: ,trx_date_from ra_customer_trx_all.trx_date%TYPE
143: ,trx_date_to ra_customer_trx_all.trx_date%TYPE
144: ,doc_num_from ra_customer_trx_all.doc_sequence_value%TYPE
145: ,doc_num_to ra_customer_trx_all.doc_sequence_value%TYPE);
146:
139: ,trx_batch_to ra_batches_all.NAME%TYPE
140: ,trx_number_from ra_customer_trx_all.trx_number%TYPE
141: ,trx_number_to ra_customer_trx_all.trx_number%TYPE
142: ,trx_date_from ra_customer_trx_all.trx_date%TYPE
143: ,trx_date_to ra_customer_trx_all.trx_date%TYPE
144: ,doc_num_from ra_customer_trx_all.doc_sequence_value%TYPE
145: ,doc_num_to ra_customer_trx_all.doc_sequence_value%TYPE);
146:
147: --Add by Yao Zhang for bug#8605196 ER3 consolidation invoice
140: ,trx_number_from ra_customer_trx_all.trx_number%TYPE
141: ,trx_number_to ra_customer_trx_all.trx_number%TYPE
142: ,trx_date_from ra_customer_trx_all.trx_date%TYPE
143: ,trx_date_to ra_customer_trx_all.trx_date%TYPE
144: ,doc_num_from ra_customer_trx_all.doc_sequence_value%TYPE
145: ,doc_num_to ra_customer_trx_all.doc_sequence_value%TYPE);
146:
147: --Add by Yao Zhang for bug#8605196 ER3 consolidation invoice
148: --The Record for the parameters of consolidation program
141: ,trx_number_to ra_customer_trx_all.trx_number%TYPE
142: ,trx_date_from ra_customer_trx_all.trx_date%TYPE
143: ,trx_date_to ra_customer_trx_all.trx_date%TYPE
144: ,doc_num_from ra_customer_trx_all.doc_sequence_value%TYPE
145: ,doc_num_to ra_customer_trx_all.doc_sequence_value%TYPE);
146:
147: --Add by Yao Zhang for bug#8605196 ER3 consolidation invoice
148: --The Record for the parameters of consolidation program
149: TYPE consolparas_rec_type IS RECORD