[Home] [Help]
VIEW: APPS.JAI_AP_TDS_LE_NAME_V
Source
View Text - Preformatted
SELECT DISTINCT JTY.LEGAL_ENTITY_ID,HR.NAME FROM JAI_AP_TDS_YEARS JTY, HR_ORGANIZATION_UNITS HR WHERE JTY.LEGAL_ENTITY_ID=HR.ORGANIZATION_ID
View Text - HTML Formatted
SELECT DISTINCT JTY.LEGAL_ENTITY_ID
, HR.NAME
FROM JAI_AP_TDS_YEARS JTY
, HR_ORGANIZATION_UNITS HR
WHERE JTY.LEGAL_ENTITY_ID=HR.ORGANIZATION_ID