View: GMD_ORG_ACCESS_VW

Product:	GMD - Process Manufacturing Product Development
Description:	View that can be used in place of org_access_view for performance tuning
Implementation/DBA Data:	APPS.GMD_ORG_ACCESS_VW

View Text

SELECT B.ORGANIZATION_CODE
, A.NAME ORGANIZATION_NAME
, B.ORGANIZATION_ID
FROM HR_ORGANIZATION_UNITS A
, MTL_PARAMETERS B
, HR_ORGANIZATION_INFORMATION HOI1
WHERE A.ORGANIZATION_ID = B.ORGANIZATION_ID
AND HOI1.ORGANIZATION_ID = B.ORGANIZATION_ID
AND HOI1.ORG_INFORMATION1 = 'INV'
AND HOI1.ORG_INFORMATION2 = 'Y'
AND (HOI1.ORG_INFORMATION_CONTEXT || '') = 'CLASS'
AND B.PROCESS_ENABLED_FLAG = 'Y'
AND (EXISTS (SELECT NULL
FROM ORG_ACCESS A1
WHERE A1.ORGANIZATION_ID = A.ORGANIZATION_ID
AND NVL(A1.DISABLE_DATE
, SYSDATE+1) >= SYSDATE
AND A1.RESPONSIBILITY_ID = FND_GLOBAL.RESP_ID
AND A1.RESP_APPLICATION_ID = FND_GLOBAL.RESP_APPL_ID) OR NOT EXISTS (SELECT NULL
FROM ORG_ACCESS A2
WHERE A2.ORGANIZATION_ID = A.ORGANIZATION_ID
AND NVL(A2.DISABLE_DATE
, SYSDATE+1) >= SYSDATE)) ORDER BY 1

Columns