APPS.JL_ZZ_TAX_VALIDATE_PKG dependencies on MTL_SYSTEM_ITEMS

Line 458: -- Category and Product Fiscal Classification from mtl_system_items / mtl_item_categories.

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

Line 549: mtl_system_items items,

545: Event.tax_event_class_code ||g_delimiter||global_attribute2 trx_business_category,
546: Lines.trx_id
547: FROM
548: ZX_TRANSACTION_LINES_GT Lines ,
549: mtl_system_items items,
550: ZX_EVNT_CLS_MAPPINGS event
551: WHERE organization_id = l_organization_id
552: AND inventory_item_id = lines.product_id
553: AND lines.product_org_id is not NULL

Line 600: FROM mtl_system_items

596: IF l_inv_item_id IS NOT NULL THEN
597:
598: SELECT l_event_class_code || g_delimiter || global_attribute2
599: INTO l_trx_biz_categ
600: FROM mtl_system_items
601: WHERE organization_id = l_organization_id
602: AND inventory_item_id = l_inv_item_id;
603:
604: ELSIF l_memo_line_id IS NOT NULL THEN

Line 708: -- Category and Product Fiscal Classification from mtl_system_items / mtl_item_categories.

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);

Line 726: -- from mtl_system_items.

722: IF zx_global_structures_pkg.trx_line_dist_tbl.product_id(p_trx_line_index) IS NOT NULL
723: AND zx_global_structures_pkg.trx_line_dist_tbl.product_org_id(p_trx_line_index) is NOT NULL THEN
724:
725: -- It is an inveontory item; Populate product_fisc_classification and trx_business_category
726: -- from mtl_system_items.
727: If zx_global_structures_pkg.trx_line_dist_tbl.trx_business_category(p_trx_line_index) is NULL then
728:
729: IF g_delimiter is NULL then
730: OPEN c_delimiter;

Line 750: mtl_system_items items

746: ||g_delimiter||items.global_attribute2
747: INTO
748: l_trx_business_category
749: FROM
750: mtl_system_items items
751: WHERE organization_id = l_organization_id
752: AND inventory_item_id = zx_global_structures_pkg.trx_line_dist_tbl.product_id(p_trx_line_index);
753:
754: