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

Price List Query for Item

 SELECT qph.list_header_id,        qph.name,        qph.description,        qphh.start_date_active,        qphh.currency_code,        q...