eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: CZFV_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
, OB.NAME
, '_DF:AK:AK_REGIONS:RE'
, RE.REGION_APPLICATION_ID
, RE.DATABASE_OBJECT_NAME
, RE.CREATION_DATE
, RE.CREATED_BY
, RE.LAST_UPDATE_DATE
, RE.LAST_UPDATED_BY
FROM AK_OBJECTS_TL OB
, 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
AND OB.DATABASE_OBJECT_NAME = RE.DATABASE_OBJECT_NAME
AND OB.LANGUAGE = USERENV('LANG') WITH READ ONLY

Columns

Name
CONFIGURATION_REGION_ID
APPLICATION_NAME
CONFIGURATION_REGION_NAME
DESCRIPTION
OBJECT_NAME
"_DF"
REGION_APPLICATION_ID
DATABASE_OBJECT_NAME
CREATED_DATE
CREATED_BY
LAST_UPDATED_DATE
LAST_UPDATED_BY