502: USING (SELECT
503: fc.classification_code product_fisc_class,
504: Lines.trx_id
505: FROM
506: zx_fc_product_fiscal_v fc,
507: mtl_item_categories mic,
508: zx_transaction_lines_gt lines ,
509: zx_trx_headers_gt header
510: WHERE
779: fc.classification_code
780: INTO
781: l_product_fisc_class
782: FROM
783: zx_fc_product_fiscal_v fc,
784: mtl_item_categories mic
785: WHERE
786: ((fc.country_code =
787: zx_global_structures_pkg.trx_line_dist_tbl.default_taxation_country(p_trx_line_index)