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!

what is join for concurrent programs and parameters

Discussion in 'Oracle Financials' started by gkpgidnan, Aug 19, 2009.

  1. gkpgidnan

    gkpgidnan Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    55
    HI everybody,

    how will we get the concurrent programs default values ..

    what is the tables for concurrent programs and parameters and what is the main join for these tables

    Thanks,
    srini
     
  2. apps_expert

    apps_expert Forum Expert

    Messages:
    325
    Likes Received:
    28
    Trophy Points:
    330
    Location:
    Chennai, India
    You need to go to the system administrator responsibility. There you have Concurrent-->Program-->Define Form. You can query for any concurrent program and click on the parameters tab to see the parameter list and their default values. The underlying tables/views can be seen from the record history.
     
  3. gkpgidnan

    gkpgidnan Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    55
    Hi,

    Greetings....,

    Nice to see your mail.

    I know that process..
    Tables are
    FND_CONCURRENT_PROGRAMS ---> This is for Concurrent Programs
    FND_DESCR_FLEX_COLUMN_USAGES --> this is for paramaeters

    i want to know the join condition for this..


    Thanks,
    Srini
     
  4. Soorya

    Soorya Guest

    DESCRIPTIVE_FLEXFIELD_NAME is key to identify the parameters of its corresponding concurrent program.

    1. SELECT CONCURRENT_PROGRAM_NAME FROM FND_CONCURRENT_PROGRAMS
    - It gives your concurrent program name
    2. SELECT * FROM FND_DESCR_FLEX_COLUMN_USAGES WHERE DESCRIPTIVE_FLEXFIELD_NAME LIKE '%<CONCURRENT_PROGRAM_NAME>%'
    - Substitute the concurrent program name in the above 2nd query