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!

How to find out custom package name and details through back end in webadi

Discussion in 'Oracle Apps Technical' started by Raviprakash, Dec 9, 2017.

  1. Raviprakash

    Raviprakash Forum Genius

    Messages:
    19
    Likes Received:
    2
    Trophy Points:
    785
    I got one requirement for Webadi related in oracle apps 11i.
    I need to find out Webadi Custom package name and details through backend in Webadi?
    How we can get the custom package names through backend?in Webadi?
    can u please help me some on this?

    Urgent?


    Thanks u so much
     
  2. Sanjeeva

    Sanjeeva Newly Initiated

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    30
    Location:
    hyderabad
    Hi,
    here's code as per my knowledge.
    >SELECT *FROM USER_SOURCE WHERE NAME LIKE 'PACKAGENAME%'
     
  3. yowancristo

    yowancristo Forum Advisor

    Messages:
    112
    Likes Received:
    10
    Trophy Points:
    305
    Location:
    Manchester, UK
    Hi,

    Please try the below one - This should give package/procedure associated with a WebADI Integrator.

    Code (SQL):
    SELECT     BA.attribute2, BT.*
    FROM       APPS.BNE_ATTRIBUTES BA,
            APPS.BNE_PARAM_LISTS_B BPL,
            APPS.BNE_INTERFACES_B  BI,
            APPS.BNE_INTEGRATORS_TL BT
    WHERE      BI.upload_param_list_code = BPL.param_list_code
    AND        BI.integrator_code = BT.integrator_code
    AND        BA.attribute_code = BPL.param_list_code || '_ATT'
    AND        LOWER(BT.user_name) LIKE LOWER('%<your webadi name>%');