View: ORG_ACCESS_V

Product:	INV - Inventory
Description:	10SC ONLY
Implementation/DBA Data:	APPS.ORG_ACCESS_V

View Text

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

Columns