[Home] [Help]
454: /* Defaulting for Transaction Business Category, Product Category and
455: Product Fiscal Classification on transaction lines */
456:
457: -- In case where the line is not a memo line, default the Transaction Business
458: -- Category and Product Fiscal Classification from mtl_system_items / mtl_item_categories.
459: -- If the line is a memo line, then populate Transaction Business Category and
460: -- Product Category from ar_memo_lines.
461:
462: IF (g_level_statement >= g_current_runtime_level ) THEN
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
511: ((fc.country_code = Header.default_taxation_country
704: /* Defaulting for Transaction Business Category, Product Category and
705: Product Fiscal Classification on transaction lines */
706:
707: -- In case where the line is not a memo line, default the Transaction Business
708: -- Category and Product Fiscal Classification from mtl_system_items / mtl_item_categories.
709: -- If the line is a memo line, then populate Transaction Business Category and
710: -- Product Category from ar_memo_lines.
711:
712: l_organization_id := zx_global_structures_pkg.trx_line_dist_tbl.product_org_id(p_trx_line_index);
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)
788: AND fc.country_code in ('AR', 'BR', 'CO'))