View: ORG_ACCESS_VIEW

Product:	INV - Inventory
Description:	Organization access view resolving all organizations available for each responsibility
Implementation/DBA Data:	APPS.ORG_ACCESS_VIEW

View Text

SELECT HOU.ORGANIZATION_ID
, R.RESPONSIBILITY_ID
, R.APPLICATION_ID RESP_APPLICATION_ID
, MP.ORGANIZATION_CODE
, HOUT.NAME ORGANIZATION_NAME
, HOU.BUSINESS_GROUP_ID
, GSOB.SET_OF_BOOKS_ID
, GSOB.CHART_OF_ACCOUNTS_ID
, HOI1.ORG_INFORMATION2 INVENTORY_ENABLED_FLAG
FROM HR_ALL_ORGANIZATION_UNITS HOU
, HR_ALL_ORGANIZATION_UNITS_TL HOUT
, HR_ORGANIZATION_INFORMATION HOI1
, HR_ORGANIZATION_INFORMATION HOI2
, MTL_PARAMETERS MP
, GL_SETS_OF_BOOKS GSOB
, FND_RESPONSIBILITY R
WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = HOI2.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND HOI1.ORG_INFORMATION1 = 'INV'
AND HOI1.ORG_INFORMATION2 = 'Y'
AND (HOI1.ORG_INFORMATION_CONTEXT || '') = 'CLASS'
AND (HOI2.ORG_INFORMATION_CONTEXT || '') = 'ACCOUNTING INFORMATION'
AND TO_NUMBER(DECODE(TRIM(TRANSLATE(HOI2.ORG_INFORMATION1
, '0123456789'
, ' '))
, NULL
, HOI2.ORG_INFORMATION1
, '-99999')) = GSOB.SET_OF_BOOKS_ID
AND NVL(HOU.DATE_TO
, SYSDATE+1) >= SYSDATE
AND DECODE(HR_SECURITY.VIEW_ALL
, 'Y'
, 'TRUE'
, HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS'
, HOUT.ORGANIZATION_ID))='TRUE'
AND DECODE(HR_GENERAL.GET_XBG_PROFILE
, 'Y'
, HOU.BUSINESS_GROUP_ID
, HR_GENERAL.GET_BUSINESS_GROUP_ID) = HOU.BUSINESS_GROUP_ID
AND HOU.ORGANIZATION_ID = HOUT.ORGANIZATION_ID
AND HOUT.LANGUAGE = USERENV('LANG')
AND (EXISTS (SELECT NULL
FROM ORG_ACCESS A1
WHERE A1.ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND NVL(A1.DISABLE_DATE
, SYSDATE+1) >= SYSDATE
AND A1.RESP_APPLICATION_ID = R.APPLICATION_ID
AND A1.RESPONSIBILITY_ID = R.RESPONSIBILITY_ID) OR NOT EXISTS (SELECT NULL
FROM ORG_ACCESS A2
WHERE A2.ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND NVL(A2.DISABLE_DATE
, SYSDATE+1) >=SYSDATE))

Columns