VIEW: APPS.MRP_ORG_DEFINITIONS_V

Source

View Text - Preformatted

SELECT HAO.ORGANIZATION_ID, HAO.BUSINESS_GROUP_ID, HAO.DATE_FROM, HAO.DATE_TO, MP.ORGANIZATION_CODE, HAOTL.NAME, GSOB.SET_OF_BOOKS_ID, GSOB.CHART_OF_ACCOUNTS_ID, HOI1.ORG_INFORMATION2, DECODE(FPG.MULTI_ORG_FLAG, 'Y', DECODE(HOI2.ORG_INFORMATION_CONTEXT,'Accounting Information', TO_NUMBER(HOI2.ORG_INFORMATION3), TO_NUMBER(NULL)),TO_NUMBER(NULL)), DECODE(HOI2.ORG_INFORMATION_CONTEXT, 'Accounting Information',TO_NUMBER(HOI2.ORG_INFORMATION2), null) FROM HR_ORGANIZATION_INFORMATION HOI1, HR_ORGANIZATION_INFORMATION HOI2, MTL_PARAMETERS MP, GL_SETS_OF_BOOKS GSOB, FND_PRODUCT_GROUPS FPG, HR_ALL_ORGANIZATION_UNITS HAO, HR_ALL_ORGANIZATION_UNITS_TL HAOTL WHERE HAO.ORGANIZATION_ID = HOI1.ORGANIZATION_ID AND HAO.ORGANIZATION_ID = HOI2.ORGANIZATION_ID AND HAO.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 HOI2.ORG_INFORMATION1 = TO_CHAR(GSOB.SET_OF_BOOKS_ID) AND HAO.ORGANIZATION_ID = HAOTL.ORGANIZATION_ID AND HAOTL.LANGUAGE = USERENV('LANG') AND DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE', HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS', HAOTL.ORGANIZATION_ID))='TRUE'

View Text - HTML Formatted

SELECT HAO.ORGANIZATION_ID
, HAO.BUSINESS_GROUP_ID
, HAO.DATE_FROM
, HAO.DATE_TO
, MP.ORGANIZATION_CODE
, HAOTL.NAME
, GSOB.SET_OF_BOOKS_ID
, GSOB.CHART_OF_ACCOUNTS_ID
, HOI1.ORG_INFORMATION2
, DECODE(FPG.MULTI_ORG_FLAG
, 'Y'
, DECODE(HOI2.ORG_INFORMATION_CONTEXT
, 'ACCOUNTING INFORMATION'
, TO_NUMBER(HOI2.ORG_INFORMATION3)
, TO_NUMBER(NULL))
, TO_NUMBER(NULL))
, DECODE(HOI2.ORG_INFORMATION_CONTEXT
, 'ACCOUNTING INFORMATION'
, TO_NUMBER(HOI2.ORG_INFORMATION2)
, NULL)
FROM HR_ORGANIZATION_INFORMATION HOI1
, HR_ORGANIZATION_INFORMATION HOI2
, MTL_PARAMETERS MP
, GL_SETS_OF_BOOKS GSOB
, FND_PRODUCT_GROUPS FPG
, HR_ALL_ORGANIZATION_UNITS HAO
, HR_ALL_ORGANIZATION_UNITS_TL HAOTL
WHERE HAO.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
AND HAO.ORGANIZATION_ID = HOI2.ORGANIZATION_ID
AND HAO.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 HOI2.ORG_INFORMATION1 = TO_CHAR(GSOB.SET_OF_BOOKS_ID)
AND HAO.ORGANIZATION_ID = HAOTL.ORGANIZATION_ID
AND HAOTL.LANGUAGE = USERENV('LANG')
AND DECODE(HR_SECURITY.VIEW_ALL
, 'Y'
, 'TRUE'
, HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS'
, HAOTL.ORGANIZATION_ID))='TRUE'