VIEW: APPS.MTL_LE_ECONOMIC_ZONES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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