[Home] [Help]
1496: l_trx_id_tbl,
1497: l_tax_rate_tbl,
1498: l_document_sub_type_tbl
1499: FROM zx_rep_trx_detail_t itf1 ,
1500: zx_fc_codes_denorm_b fc
1501: WHERE itf1.request_id = P_REQUEST_ID
1502: AND itf1.cancel_flag = 'N'
1503: -- AND itf1.posted_flag = 'Y' --Bug 5413860
1504: AND ( itf1.reverse_flag IS NULL OR itf1.reverse_flag <>'Y')