How to check which concurrent request assign to which responsibility

Hi Folks,

It is very difficult to find out from the front end to which concurrent request is assign to which responsibility.

below is the query to identify which is suitable responsibility for the concurrent request.

SELECT FRT.RESPONSIBILITY_NAME, FRG.REQUEST_GROUP_NAME, FRG.DESCRIPTION ,frt.*

  FROM FND_REQUEST_GROUPS FRG

      ,FND_REQUEST_GROUP_UNITS FRGU

      ,FND_CONCURRENT_PROGRAMS FCP

      ,FND_CONCURRENT_PROGRAMS_TL FCPT

      ,FND_RESPONSIBILITY_TL FRT

      ,FND_RESPONSIBILITY FR

 WHERE     FRGU.UNIT_APPLICATION_ID = FCP.APPLICATION_ID

       AND FRGU.REQUEST_UNIT_ID = FCP.CONCURRENT_PROGRAM_ID

       AND FRG.REQUEST_GROUP_ID = FRGU.REQUEST_GROUP_ID

       AND FRG.APPLICATION_ID = FRGU.APPLICATION_ID

       AND FCPT.SOURCE_LANG = USERENV('LANG')

       AND FCP.APPLICATION_ID = FCPT.APPLICATION_ID

       AND FCP.CONCURRENT_PROGRAM_ID = FCPT.CONCURRENT_PROGRAM_ID

       AND FR.APPLICATION_ID = FRT.APPLICATION_ID

       AND FR.RESPONSIBILITY_ID = FRT.RESPONSIBILITY_ID

       AND FRT.SOURCE_LANG = USERENV('LANG')

       AND FR.REQUEST_GROUP_ID = FRG.REQUEST_GROUP_ID

       AND FR.APPLICATION_ID = FRG.APPLICATION_ID

       --   AND FCP.CONCURRENT_PROGRAM_NAME = 'OPMTMOPG'  --  YOU CAN PUT THE SHORTNAME HERE

       AND FCPT.USER_CONCURRENT_PROGRAM_NAME  = :Request_name --OR THE USER CONC PROGRAM NAME HERE;

Oracle Apps Miscellaneous Transactions

Miscellaneous Transactions:-

Miscellaneous receipt:- You can do the Miscellaneous transaction to increase On hand Qty of Item from general ledger account in your current organization.

You can also make manual adjustment to the general receiving material from one account  in inventory

Miscellaneous Issue:- You can do the Miscellaneous transaction to decrease On hand Qty of Item  from general ledger account in your current organization.

You can also make manual adjustment to the general receiving material from one account in inventory

Navigate to Miscellaneous Transactions

1.   Enter the date and time of entry for the transaction

2.   Enter a miscellaneous transaction type for the transfer(Issue or Receipt)

3.   Optionally, enter the source of the transaction type

4.   Optionally, enter the general ledger account against which the material is issued or received.

5.   Optionally, indicate if inventory information should be defaulted from the serial number.

To enter the Item Information:- 

1.   Enter an inventory item to issue or receive

2.   Enter a sub inventory and locator

3.   Enter the Lot Number if the item is Lot/Serial Controlled

4.   Enter the Quantity

Save your Work

This will Increase or Decrease On Hand....!!