VIEW: APPS.MTH_SRC_ORGANIZATIONS_V

Source

View Text - Preformatted

SELECT hou.NAME ORGANIZATION_NAME, mp.PROCESS_ENABLED_FLAG PROCESS_ENABLED_FLAG, gl.CURRENCY_CODE CURRENCY_CODE, hou.ORGANIZATION_ID EBS_ORGANIZATION_ID, mp.PRIMARY_COST_METHOD PRIMARY_COST_METHOD, mp.ORGANIZATION_CODE ORGANIZATION_CODE, fnd_profile.value('MTH_EBS_GLOBAL_NAME') SYSTEM_FK, mp_eam.ORGANIZATION_CODE EAM_ORGANIZATION_CODE, mp.ATTRIBUTE1 USER_ATTR1, mp.ATTRIBUTE2 USER_ATTR2, mp.ATTRIBUTE3 USER_ATTR3, mp.ATTRIBUTE4 USER_ATTR4, mp.ATTRIBUTE5 USER_ATTR5, CAST(NULL AS NUMBER) USER_MEASURE1, CAST(NULL AS NUMBER) USER_MEASURE2, CAST(NULL AS NUMBER) USER_MEASURE3, CAST(NULL AS NUMBER) USER_MEASURE4, CAST(NULL AS NUMBER) USER_MEASURE5 FROM MTL_PARAMETERS mp, HR_ORGANIZATION_INFORMATION hoi, GL_SETS_OF_BOOKS gl, HR_ALL_ORGANIZATION_UNITS_TL hou, MTL_PARAMETERS mp_eam WHERE hou.ORGANIZATION_ID = mp.ORGANIZATION_ID AND mp.ORGANIZATION_ID = hoi.ORGANIZATION_ID AND hoi.ORG_INFORMATION1 = TO_CHAR( gl.SET_OF_BOOKS_ID ) AND hoi.ORG_INFORMATION_CONTEXT = 'Accounting Information' AND hou.LANGUAGE = USERENV ('LANG') AND mp.maint_organization_id = mp_eam.organization_id (+)

View Text - HTML Formatted

SELECT HOU.NAME ORGANIZATION_NAME
, MP.PROCESS_ENABLED_FLAG PROCESS_ENABLED_FLAG
, GL.CURRENCY_CODE CURRENCY_CODE
, HOU.ORGANIZATION_ID EBS_ORGANIZATION_ID
, MP.PRIMARY_COST_METHOD PRIMARY_COST_METHOD
, MP.ORGANIZATION_CODE ORGANIZATION_CODE
, FND_PROFILE.VALUE('MTH_EBS_GLOBAL_NAME') SYSTEM_FK
, MP_EAM.ORGANIZATION_CODE EAM_ORGANIZATION_CODE
, MP.ATTRIBUTE1 USER_ATTR1
, MP.ATTRIBUTE2 USER_ATTR2
, MP.ATTRIBUTE3 USER_ATTR3
, MP.ATTRIBUTE4 USER_ATTR4
, MP.ATTRIBUTE5 USER_ATTR5
, CAST(NULL AS NUMBER) USER_MEASURE1
, CAST(NULL AS NUMBER) USER_MEASURE2
, CAST(NULL AS NUMBER) USER_MEASURE3
, CAST(NULL AS NUMBER) USER_MEASURE4
, CAST(NULL AS NUMBER) USER_MEASURE5
FROM MTL_PARAMETERS MP
, HR_ORGANIZATION_INFORMATION HOI
, GL_SETS_OF_BOOKS GL
, HR_ALL_ORGANIZATION_UNITS_TL HOU
, MTL_PARAMETERS MP_EAM
WHERE HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND MP.ORGANIZATION_ID = HOI.ORGANIZATION_ID
AND HOI.ORG_INFORMATION1 = TO_CHAR( GL.SET_OF_BOOKS_ID )
AND HOI.ORG_INFORMATION_CONTEXT = 'ACCOUNTING INFORMATION'
AND HOU.LANGUAGE = USERENV ('LANG')
AND MP.MAINT_ORGANIZATION_ID = MP_EAM.ORGANIZATION_ID (+)