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 check Oracle Apps Modules Licensed or not

Discussion in 'General' started by jagadekara, Sep 13, 2014.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    The following is a Query to check if Oracle Apps Modules Licensed or not

    Code (SQL):
    SELECT fat.application_name
          ,fa.application_id
          ,fpi.patch_level
          ,decode(fpi.STATUS,'I','Licensed', 'N','Not Licensed','S','Shared','Undetermined') STATUS
      FROM fnd_product_installations fpi
          ,fnd_application fa
          ,fnd_application_tl fat
     WHERE fpi.application_id = fa.application_id
       AND fat.application_id = fa.application_id
       AND fat.LANGUAGE = 'US';