EBS Request set SQL query information

EBS Request Set

SELECT FA.APPLICATION_SHORT_NAME,
       FRS.REQUEST_SET_ID,
       REQUEST_SET_NAME,
       FRST.USER_REQUEST_SET_NAME,
       FRST.DESCRIPTION,
       START_DATE_ACTIVE,
       START_STAGE       
  FROM FND_REQUEST_SETS FRS
     , FND_REQUEST_SETS_TL FRST
     , FND_APPLICATION FA
 WHERE     FRS.REQUEST_SET_ID = FRST.REQUEST_SET_ID
       AND FA.APPLICATION_ID = FRS.APPLICATION_ID;

 SELECT FA.APPLICATION_SHORT_NAME,
         FRS.REQUEST_SET_ID,
         REQUEST_SET_NAME,
         FRST.USER_REQUEST_SET_NAME,
         FRST.DESCRIPTION,
         START_DATE_ACTIVE,
         START_STAGE,
         FRSS.USER_STAGE_NAME
    FROM FND_REQUEST_SETS FRS,
         FND_REQUEST_SETS_TL FRST,
         FND_APPLICATION FA,
         FND_REQUEST_SET_STAGES_TL FRSS
   WHERE     FRS.REQUEST_SET_ID = FRST.REQUEST_SET_ID
         AND FA.APPLICATION_ID = FRS.APPLICATION_ID
         AND FRS.REQUEST_SET_ID = FRSS.REQUEST_SET_ID
ORDER BY 1, 2, 8;

Leave a Comment

Your email address will not be published.