[Home] [Help]
653: /* Defaulting for Transaction Business Category, Product Category and
654: Product Fiscal Classification on transaction lines */
655:
656: -- In case where the line is not a memo line, default the Transaction Business
657: -- Category and Product Fiscal Classification from mtl_system_items / mtl_item_categories.
658: -- If the line is a memo line, then populate Transaction Business Category and
659: -- Product Category from ar_memo_lines.
660:
661: IF (g_level_statement >= g_current_runtime_level ) THEN
704: Lines.trx_line_id,
705: Lines.trx_level_type
706: FROM
707: zx_fc_product_fiscal_v fc,
708: mtl_item_categories mic,
709: zx_transaction_lines_gt lines ,
710: zx_trx_headers_gt header
711: WHERE
712: ((fc.country_code = Header.default_taxation_country
899: /* Defaulting for Transaction Business Category, Product Category and
900: Product Fiscal Classification on transaction lines */
901:
902: -- In case where the line is not a memo line, default the Transaction Business
903: -- Category and Product Fiscal Classification from mtl_system_items / mtl_item_categories.
904: -- If the line is a memo line, then populate Transaction Business Category and
905: -- Product Category from ar_memo_lines.
906:
907: l_organization_id := zx_global_structures_pkg.trx_line_dist_tbl.product_org_id(p_trx_line_index);
976: INTO
977: l_product_fisc_class
978: FROM
979: zx_fc_product_fiscal_v fc,
980: mtl_item_categories mic
981: WHERE
982: ((fc.country_code =
983: zx_global_structures_pkg.trx_line_dist_tbl.default_taxation_country(p_trx_line_index)
984: AND fc.country_code in ('AR', 'BR', 'CO'))