VIEW: APPS.GMD_ORG_ACCESS_VW

Source

View Text - Preformatted

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

View Text - HTML Formatted

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