1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Query To Display Items which are not assigned to VAT Template

Discussion in 'Oracle Apps Technical' started by jagadekara, Sep 29, 2014.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Query To Display Items which are not assigned to VAT Template

    Code (SQL):
    SELECT ood.organization_name
             ,msi.*
       FROM mtl_system_items_b msi
           ,org_organization_definitions ood
       WHERE 1=1
       AND msi.organization_id=ood.organization_id
       AND inventory_item_id NOT IN
             (SELECT inventory_item_id FROM jai_rgm_tmpl_itm_regns);
    Let me know, If I am wrong.