Skip to main content

Query : Find Request Group name for Concurrent program name

By
Very useful query to retreive the Request Group and other information for Concurrent program from its name :
 
SELECT cpt.user_concurrent_program_name     "Concurrent Program Name",
       DECODE(rgu.request_unit_type,
              'P', 'Program',
              'S', 'Set',
              rgu.request_unit_type)        "Unit Type",
       cp.concurrent_program_name           "Concurrent Program Short Name",
       rg.application_id                    "Application ID",
       rg.request_group_name                "Request Group Name",
       fat.application_name                 "Application Name",
       fa.application_short_name            "Application Short Name",
       fa.basepath                          "Basepath"
         FROM fnd_request_groups          rg,
       fnd_request_group_units     rgu,
       fnd_concurrent_programs     cp,
       fnd_concurrent_programs_tl  cpt,
       fnd_application             fa,
       fnd_application_tl          fat
 WHERE rg.request_group_id       =  rgu.request_group_id
   AND rgu.request_unit_id       =  cp.concurrent_program_id
   AND cp.concurrent_program_id  =  cpt.concurrent_program_id
   AND rg.application_id         =  fat.application_id
   AND fa.application_id         =  fat.application_id
   AND cpt.language              =  USERENV('LANG')
   AND fat.language              =  USERENV('LANG')
   AND cpt.user_concurrent_program_name like 'Your CP Name';

Comments

Post a Comment

Popular posts from this blog

Use of Who Columns in Oracle APPS table

By
Oracle APPS : WHO COLUMNS WHO columns are used to track the information updated or inserted by the users against the tables. FND_STANDARD package is used for this purpose. FND_STANDARD.SET_WHO Procedure is used to update the WHO columns in a Table when a DML operation s (i.e. INSERT, UPDATE) performed. Steps required to Track WHO Information in our form   1. ALTER the table by adding WHO columns in the table.   2. Open TEMPLATE.fmb in form Builder.   3. Perform all the pre‐requisites to develop a form.   4. Include all the WHO columns in the Data Block with NULL Canvas.   5. Call FND_STAND.SET_WHO procedure in Pre‐Insert and Pre‐Update triggers       at Block Level.   6. Save and Compile the Form.   7. Perform all the pre‐requisites to register the form Note: 1. WHO Columns need not register with the table registration option.           2. Table registration will be done only for KFF and DFF col...
Post a Comment
Read more

Oracle APPS Create Responsibility and User in Oracle EBS

By
How to create Responsibility and User in Oracle EBS How to Create a Responsibility? Step 1: Connect to Oracle Application with APPSADMIN/APPSADMIN User. Step 2: Go to Application Administrator. Step 3: Go to Security then Responsibility then Define Step 4: Enter the Data in the opened Window. Note: Above Information of Responsibility is stored in FND_RESPONSIBILITY Table. How to Create a User? Step 1: Connect to Oracle Application with APPSADMIN/APPSADMIN User. Step 2: Go to Application Administrator. Step 3: Go to Security then User then Define Step 4: Enter the Data in the opened Window. Note: Above Information of User is stored in FND_USER Table. User Responsibilities stored in FND_USER_RESP_GROUPS Table.
2 comments
Read more

Setup steps for Drop Shipments in Oracle EBS

By
  Oracle Order Entry and Oracle Purchasing integrate to provide drop shipments. Drop shipments are orders for items that your supplier ships directly to the customer either because you don't stock or currently have the items in inventory, or because it's more cost-effective for the supplier to ship the item to the customer directly SETUP A) Associate drop shipments with a receiving location. B) Drop shipments support a Destination Type of Expense or Inventory only. C) We can handle returns of drop shipments using standard Order Entry/Shipping or Purchasing functionality. There are different ways you may want to handle returns depending on whether the customer returned the item to you or directly to the supplier. We have to consider the following setup: 1- Inventory Setup  Inventory Setup : (Define and Maintain The Item) The drop ship inventory organization, item and subinventory must be setup prior to creating any drop ship orders. All drop ship ...
3 comments
Read more