Monday, October 9, 2017

Concurrent program attached request Group - Query

SELECT FRT.RESPONSIBILITY_NAME,
       FRG.REQUEST_GROUP_NAME,
       FRGU.REQUEST_UNIT_TYPE,
       FRGU.REQUEST_UNIT_ID,
       FCPT.USER_CONCURRENT_PROGRAM_NAME
  FROM FND_RESPONSIBILITY         FR,
       FND_RESPONSIBILITY_TL      FRT,
       FND_REQUEST_GROUPS         FRG,
       FND_REQUEST_GROUP_UNITS    FRGU,
       FND_CONCURRENT_PROGRAMS_TL FCPT
 WHERE FRT.RESPONSIBILITY_ID = FR.RESPONSIBILITY_ID
   AND FRG.REQUEST_GROUP_ID = FR.REQUEST_GROUP_ID
   AND FRGU.REQUEST_GROUP_ID = FRG.REQUEST_GROUP_ID
   AND FCPT.CONCURRENT_PROGRAM_ID = FRGU.REQUEST_UNIT_ID
   AND FRT.LANGUAGE = USERENV('LANG')
   AND FCPT.LANGUAGE = USERENV('LANG')
   AND FCPT.USER_CONCURRENT_PROGRAM_NAME =
       'PO Changes'
 ORDER BY 1, 2, 3, 4


No comments:

Post a Comment

Item - Category Query

      SELECT      msi.segment1 AS Item_Code,       msi.DESCRIPTION AS Item_Desc,       mcs.CATEGORY_SET_NAME,       mck.CONCATENATED_SEGMEN...