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