How to get the form_id or function_id or function_name?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Cessaar
    New Member
    • Sep 2008
    • 5

    How to get the form_id or function_id or function_name?

    Hi Masters:

    in Oracle Apps i need to get the function_id, function_name or form_id to create a customized code... how can i get that?

    thanks in advance
    Cesar L V.
  • amitpatel66
    Recognized Expert Top Contributor
    • Mar 2007
    • 2358

    #2
    Try this:

    [code=oracle]
    SQL> ed
    Wrote file afiedt.buf

    1 SELECT fff.function_na me,
    2 ff.form_name,
    3 ffft.user_funct ion_name,
    4 fff.function_id ,
    5 ff.form_id,
    6 fff.application _id
    7 FROM fnd_form ff,
    8 fnd_form_functi ons fff,
    9 fnd_form_functi ons_tl ffft
    10 WHERE ff.form_id = fff.form_id
    11 AND fff.function_id = ffft.function_i d
    12* AND ffft.language = 'US'
    SQL>

    [/code]

    Comment

    • Cessaar
      New Member
      • Sep 2008
      • 5

      #3
      thanks a lot, amitpatel66...

      in the oracle applications (EBS)... i trying to create a personalization , how can i get the function_id or the function_name?. .. because in the application, i have 2 diferent functions using the same form... and i need only one fuction applies that personalization ...

      excuse my english...
      thanks a lot for your (very appreciated) time
      happy new year!

      Comment

      • amitpatel66
        Recognized Expert Top Contributor
        • Mar 2007
        • 2358

        #4
        You can open the particular form to which the function is assigned that you want to customize then you can do your customization using forms personalization .

        I am not sure what you are exactly trying to achieve.
        If you can provide more information would help.

        Comment

        • Cessaar
          New Member
          • Sep 2008
          • 5

          #5
          a Lot of Thanks, AmitPatel66...

          but i have 2 functions (example: function1 and function2) who calls the same Forms (example: ARXFORM1), so... i create the personalization on ARXFORM1, so, if you only access function1 the personalization applies....

          my problem is: accessing function2, the personalization applies too, and i dont want this.

          how can i "split" or what condition i need to create in the personalization to differenciate the accessing function

          ---EXCUSE MY POOR ENGLISH!
          Thanks in advance
          Cesar

          Comment

          • amitpatel66
            Recognized Expert Top Contributor
            • Mar 2007
            • 2358

            #6
            Is your fmb a custom one or a standard one? Then I am afraid you will need to create a copy of that fmb with different name and assign the same to another function and apply the personalization to the same.

            Comment

            • Cessaar
              New Member
              • Sep 2008
              • 5

              #7
              thanks a lot amitpatel66.... have a good life!

              Comment

              Working...