[Home] [Help]
View: CZBV_CONFIGURATION_REGIONS
Product: | BOM - Bills of Material |
Description: | - Retrofitted |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT RE.REGION_CODE
, AP.APPLICATION_NAME
, RETL.NAME
, RETL.DESCRIPTION
, RE.REGION_APPLICATION_ID
, RE.DATABASE_OBJECT_NAME
, RE.CREATION_DATE
, RE.CREATED_BY
, RE.LAST_UPDATE_DATE
, RE.LAST_UPDATED_BY
FROM FND_APPLICATION_VL AP
, AK_REGIONS_TL RETL
, AK_REGIONS RE
WHERE RE.REGION_APPLICATION_ID = RETL.REGION_APPLICATION_ID
AND RE.REGION_CODE = RETL.REGION_CODE
AND RETL.LANGUAGE = USERENV('LANG')
AND RE.REGION_APPLICATION_ID = 702
AND RE.DATABASE_OBJECT_NAME = 'MTL_SYSTEM_ITEMS_KFV'
AND RE.REGION_APPLICATION_ID = AP.APPLICATION_ID WITH READ ONLY
Columns
Name |
CONFIGURATION_REGION_ID |
APPLICATION_NAME |
CONFIGURATION_REGION_NAME |
DESCRIPTION |
REGION_APPLICATION_ID |
DATABASE_OBJECT_NAME |
CREATED_DATE |
CREATED_BY |
LAST_UPDATED_DATE |
LAST_UPDATED_BY |