VIEW: APPS.CZ_EXV_ORGANIZATIONS

Source

View Text - Preformatted

SELECT A.organization_id ORGANIZATION_ID, b.organization_code ORGANIZATION_CODE, A.name ORGANIZATION_NAME  FROM hr_all_organization_units A,  	mtl_parameters b,  	hr_organization_information c, 	hr_organization_information c1,  	gl_sets_of_books gsob WHERE A.organization_id = b.organization_id AND A.organization_id = c.organization_id AND A.organization_id = c1.organization_id AND c.org_information1 = 'INV' AND  c.ORG_INFORMATION2 = 'Y'  AND ( c.ORG_INFORMATION_CONTEXT || '') = 'CLASS' AND ( c1.ORG_INFORMATION_CONTEXT || '') ='Accounting Information'  AND c1.ORG_INFORMATION1 = TO_CHAR(GSOB.SET_OF_BOOKS_ID)

View Text - HTML Formatted

SELECT A.ORGANIZATION_ID ORGANIZATION_ID
, B.ORGANIZATION_CODE ORGANIZATION_CODE
, A.NAME ORGANIZATION_NAME
FROM HR_ALL_ORGANIZATION_UNITS A
, MTL_PARAMETERS B
, HR_ORGANIZATION_INFORMATION C
, HR_ORGANIZATION_INFORMATION C1
, GL_SETS_OF_BOOKS GSOB
WHERE A.ORGANIZATION_ID = B.ORGANIZATION_ID
AND A.ORGANIZATION_ID = C.ORGANIZATION_ID
AND A.ORGANIZATION_ID = C1.ORGANIZATION_ID
AND C.ORG_INFORMATION1 = 'INV'
AND C.ORG_INFORMATION2 = 'Y'
AND ( C.ORG_INFORMATION_CONTEXT || '') = 'CLASS'
AND ( C1.ORG_INFORMATION_CONTEXT || '') ='ACCOUNTING INFORMATION'
AND C1.ORG_INFORMATION1 = TO_CHAR(GSOB.SET_OF_BOOKS_ID)