64: tax_amount NUMBER,
65: freight_amount NUMBER,
66: charge_amount NUMBER,
67: reversed_cash_receipt_id NUMBER,
68: trx_type ra_cust_trx_types.type%type,
69: is_open_receivable BOOLEAN,
70: is_postable BOOLEAN,
71: is_child BOOLEAN,
72: is_onacct_cm BOOLEAN,
71: is_child BOOLEAN,
72: is_onacct_cm BOOLEAN,
73: previous_customer_trx_id BINARY_INTEGER,
74: initial_customer_trx_id BINARY_INTEGER,
75: initial_trx_type ra_cust_trx_types.type%type
76: );
77:
78: /* VAT changes */
79: SUBTYPE ae_doc_rec_type IS arp_acct_main.ae_doc_rec_type;
216: p_control_rec.previous_customer_trx_id,
217: p_control_rec.initial_customer_trx_id,
218: p_control_rec.initial_trx_type
219: FROM
220: ra_cust_trx_types ctt_init,
221: ra_customer_trx ct_init,
222: ra_cust_trx_types ctt,
223: ra_customer_trx ct
224: WHERE ct.customer_trx_id = p_control_rec.customer_trx_id
218: p_control_rec.initial_trx_type
219: FROM
220: ra_cust_trx_types ctt_init,
221: ra_customer_trx ct_init,
222: ra_cust_trx_types ctt,
223: ra_customer_trx ct
224: WHERE ct.customer_trx_id = p_control_rec.customer_trx_id
225: and ct.cust_trx_type_id = ctt.cust_trx_type_id
226: and ct.initial_customer_trx_id = ct_init.customer_trx_id(+)
271: FROM
272: ra_customer_trx ct,
273: ra_customer_trx ct_prev,
274: ra_customer_trx ct_init,
275: ra_cust_trx_types ctt_init
276: WHERE ct.customer_trx_id = p_control_rec.customer_trx_id
277: and ct.previous_customer_trx_id = ct_prev.customer_trx_id
278: and ct_prev.initial_customer_trx_id = ct_init.customer_trx_id(+)
279: and ct_init.cust_trx_type_id = ctt_init.cust_trx_type_id(+);