View: EGO_FND_OBJECTS_V

Product:	EGO - Advanced Product Catalog
Description:	View contains data from FND_OBJECTS and EGO_FND_OBJECTS_EXT.
Implementation/DBA Data:	APPS.EGO_FND_OBJECTS_V

View Text

SELECT OBJ.OBJECT_ID
, OBJ.OBJ_NAME OBJECT_NAME
, OBJ.APPLICATION_ID
, OBJ.DATABASE_OBJECT_NAME
, OBJ.PK1_COLUMN_NAME
, OBJ.PK2_COLUMN_NAME
, OBJ.PK3_COLUMN_NAME
, OBJ.PK4_COLUMN_NAME
, OBJ.PK5_COLUMN_NAME
, OBJ_TL.DISPLAY_NAME
, OBJ_TL.DESCRIPTION
, EXT.VIEW_PRIVILEGE
, EXT.NAME_DESC_SELECT_SQL
, EXT.PARENT_OBJECT_ID
FROM FND_OBJECTS OBJ
, FND_OBJECTS_TL OBJ_TL
, EGO_FND_OBJECTS_EXT EXT
WHERE OBJ.OBJECT_ID= OBJ_TL.OBJECT_ID
AND OBJ_TL.LANGUAGE= USERENV('LANG')
AND OBJ.OBJ_NAME = EXT.OBJECT_NAME

Columns