View: MTL_LE_ECONOMIC_ZONES_V

Product:	INV - Inventory
Description:	Join between the table MTL_Le_Economic_Zones, the view MTL_Economic_Zones_VL and HR_Legal_Entities
Implementation/DBA Data:	APPS.MTL_LE_ECONOMIC_ZONES_V

View Text

SELECT A.ROWID ROW_ID
, A.LEGAL_ENTITY_ID
, A.ZONE_CODE
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN
, C.NAME
, B.ZONE_DISPLAY_NAME
, B.ZONE_DESCRIPTION
FROM MTL_LE_ECONOMIC_ZONES A
, MTL_ECONOMIC_ZONES_VL B
, XLE_FIRSTPARTY_INFORMATION_V C
WHERE A.ZONE_CODE = B.ZONE_CODE
AND A.LEGAL_ENTITY_ID = C.LEGAL_ENTITY_ID

Columns