DBA Data[Home] [Help]

VIEW: APPS.IES_META_OBJ_RELATIONSHIPS_V

Source

View Text - Preformatted

SELECT a.primary_obj_id primary_obj_id, decode(a.secondary_obj_id, a.primary_obj_id, null, a.secondary_obj_id) secondary_obj_id FROM ies_meta_obj_relationships a 
View Text - HTML Formatted

SELECT A.PRIMARY_OBJ_ID PRIMARY_OBJ_ID
, DECODE(A.SECONDARY_OBJ_ID
, A.PRIMARY_OBJ_ID
, NULL
, A.SECONDARY_OBJ_ID) SECONDARY_OBJ_ID
FROM IES_META_OBJ_RELATIONSHIPS A