[Home] [Help]
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
Name |
ROW_ID |
LEGAL_ENTITY_ID |
ZONE_CODE |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
NAME |
ZONE_DISPLAY_NAME |
ZONE_DESCRIPTION |