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;