eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.ORG_ACCESS_V

Source

View Text - Preformatted


SELECT OA.ORGANIZATION_ID , OA.ROWID ROW_ID , OA.RESP_APPLICATION_ID , OA.RESPONSIBILITY_ID , OA.LAST_UPDATE_DATE , OA.LAST_UPDATED_BY , OA.CREATION_DATE , OA.CREATED_BY , OA.LAST_UPDATE_LOGIN , OA.DISABLE_DATE , OA.COMMENTS , OA.REQUEST_ID , OA.PROGRAM_APPLICATION_ID , OA.PROGRAM_ID , OA.PROGRAM_UPDATE_DATE , HOU.NAME ORGANIZATION_NAME , MP.ORGANIZATION_CODE , FR.RESPONSIBILITY_NAME , FA.APPLICATION_NAME FROM ORG_ACCESS OA, MTL_PARAMETERS MP, HR_ORGANIZATION_UNITS HOU, FND_RESPONSIBILITY_VL FR, FND_APPLICATION_VL FA WHERE HOU.ORGANIZATION_ID = OA.ORGANIZATION_ID AND MP.ORGANIZATION_ID = HOU.ORGANIZATION_ID AND FR.RESPONSIBILITY_ID = OA.RESPONSIBILITY_ID AND FR.APPLICATION_ID = OA.RESP_APPLICATION_ID AND FA.APPLICATION_ID = OA.RESP_APPLICATION_ID

View Text - HTML Formatted

SELECT OA.ORGANIZATION_ID
, OA.ROWID ROW_ID
, OA.RESP_APPLICATION_ID
, OA.RESPONSIBILITY_ID
, OA.LAST_UPDATE_DATE
, OA.LAST_UPDATED_BY
, OA.CREATION_DATE
, OA.CREATED_BY
, OA.LAST_UPDATE_LOGIN
, OA.DISABLE_DATE
, OA.COMMENTS
, OA.REQUEST_ID
, OA.PROGRAM_APPLICATION_ID
, OA.PROGRAM_ID
, OA.PROGRAM_UPDATE_DATE
, HOU.NAME ORGANIZATION_NAME
, MP.ORGANIZATION_CODE
, FR.RESPONSIBILITY_NAME
, FA.APPLICATION_NAME
FROM ORG_ACCESS OA
, MTL_PARAMETERS MP
, HR_ORGANIZATION_UNITS HOU
, FND_RESPONSIBILITY_VL FR
, FND_APPLICATION_VL FA
WHERE HOU.ORGANIZATION_ID = OA.ORGANIZATION_ID
AND MP.ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND FR.RESPONSIBILITY_ID = OA.RESPONSIBILITY_ID
AND FR.APPLICATION_ID = OA.RESP_APPLICATION_ID
AND FA.APPLICATION_ID = OA.RESP_APPLICATION_ID