DBA Data[Home] [Help]

VIEW: APPS.ORG_ORG_DEFINITIONS_ALL_V

Source

View Text - Preformatted

SELECT OOD.ORGANIZATION_CODE , OOD.ORGANIZATION_NAME , OOD.ORGANIZATION_ID FROM ORG_ORGANIZATION_DEFINITIONS OOD, FINANCIALS_SYSTEM_PARAMETERS FSP WHERE FSP.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID
View Text - HTML Formatted

SELECT OOD.ORGANIZATION_CODE
, OOD.ORGANIZATION_NAME
, OOD.ORGANIZATION_ID
FROM ORG_ORGANIZATION_DEFINITIONS OOD
, FINANCIALS_SYSTEM_PARAMETERS FSP
WHERE FSP.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID