7 Replies Latest reply on Apr 13, 2017 6:09 AM by Muhammad Masoom Ansari

    Which item belongs to which template

    Muhammad Masoom Ansari

      Dear All,

      I need to join mtl_system_items_b with mtl_item_templates but could not find any link through multiple tables to get the desired value. my template_id=81 which is 'store locator' now I want how many items belongs to this specific template.

      I tried multiple tables such as

      1- mtl_item_templ_attributes

      2-mtl_item_templates

      3-mtl_item_system_items_b   etc

      in etrm oracle says about one template view that it is not for database.

      regards.