[Home] [Help]
View: MTL_COUNTRY_ASSIGNMENTS_V
View Text
SELECT MCA.ROWID ROW_ID
, MCA.ZONE_CODE
, MCA.TERRITORY_CODE
, MCA.CREATION_DATE
, MCA.CREATED_BY
, MCA.LAST_UPDATE_DATE
, MCA.LAST_UPDATED_BY
, MCA.LAST_UPDATE_LOGIN
, FTV.TERRITORY_SHORT_NAME
, MCA.START_DATE
, MCA.END_DATE
FROM FND_TERRITORIES_VL FTV
, MTL_COUNTRY_ASSIGNMENTS MCA
WHERE FTV.TERRITORY_CODE = MCA.TERRITORY_CODE
Columns
Name |
ROW_ID |
ZONE_CODE |
TERRITORY_CODE |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
TERRITORY_SHORT_NAME |
START_DATE |
END_DATE |