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.

VIEW: APPS.XLA_REFERENCE_OBJECTS_F_V

Source

View Text - Preformatted


SELECT b.rowid row_id , b.application_id , b.entity_code , b.event_class_code , b.object_name , b.reference_object_appl_id , t.application_name reference_object_appl_name , b.reference_object_name , b.always_populated_flag , b.join_condition , b.creation_date , b.created_by , b.last_update_date , b.last_updated_by , b.last_update_login , b.linked_to_ref_obj_appl_id , t1.application_name linked_to_ref_obj_appl_name , b.linked_to_ref_obj_name FROM xla_reference_objects b , fnd_application_tl t , fnd_application_tl t1 WHERE b.reference_object_appl_id = t.application_id AND t.language = USERENV('LANG') AND b.linked_to_ref_obj_appl_id = t1.application_id (+) AND t1.language (+)= USERENV('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.APPLICATION_ID
, B.ENTITY_CODE
, B.EVENT_CLASS_CODE
, B.OBJECT_NAME
, B.REFERENCE_OBJECT_APPL_ID
, T.APPLICATION_NAME REFERENCE_OBJECT_APPL_NAME
, B.REFERENCE_OBJECT_NAME
, B.ALWAYS_POPULATED_FLAG
, B.JOIN_CONDITION
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.LINKED_TO_REF_OBJ_APPL_ID
, T1.APPLICATION_NAME LINKED_TO_REF_OBJ_APPL_NAME
, B.LINKED_TO_REF_OBJ_NAME
FROM XLA_REFERENCE_OBJECTS B
, FND_APPLICATION_TL T
, FND_APPLICATION_TL T1
WHERE B.REFERENCE_OBJECT_APPL_ID = T.APPLICATION_ID
AND T.LANGUAGE = USERENV('LANG')
AND B.LINKED_TO_REF_OBJ_APPL_ID = T1.APPLICATION_ID (+)
AND T1.LANGUAGE (+)= USERENV('LANG')