VIEW: APPS.XLA_EVENT_CLASS_PREDECS_F_V

Source

View Text - Preformatted

SELECT ecp.rowid row_id ,ecp.application_id application_id ,ecp.event_class_code event_class_code ,ecp.prior_event_class_code prior_event_class_code ,eca.name prior_event_class_name ,eca.description description ,eta.name prior_entity_name ,ecp.creation_date creation_date ,ecp.created_by created_by ,ecp.last_update_date last_update_date ,ecp.last_updated_by last_updated_by ,ecp.last_update_login last_update_login FROM xla_event_class_predecs ecp ,xla_event_classes_tl eca ,xla_entity_types_tl eta WHERE ecp.application_id = eca.application_id AND ecp.prior_event_class_code = eca.event_class_code AND eca.language = USERENV('LANG') AND eca.application_id = eta.application_id AND eca.entity_code = eta.entity_code AND eta.language = USERENV('LANG')

View Text - HTML Formatted

SELECT ECP.ROWID ROW_ID
, ECP.APPLICATION_ID APPLICATION_ID
, ECP.EVENT_CLASS_CODE EVENT_CLASS_CODE
, ECP.PRIOR_EVENT_CLASS_CODE PRIOR_EVENT_CLASS_CODE
, ECA.NAME PRIOR_EVENT_CLASS_NAME
, ECA.DESCRIPTION DESCRIPTION
, ETA.NAME PRIOR_ENTITY_NAME
, ECP.CREATION_DATE CREATION_DATE
, ECP.CREATED_BY CREATED_BY
, ECP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ECP.LAST_UPDATED_BY LAST_UPDATED_BY
, ECP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM XLA_EVENT_CLASS_PREDECS ECP
, XLA_EVENT_CLASSES_TL ECA
, XLA_ENTITY_TYPES_TL ETA
WHERE ECP.APPLICATION_ID = ECA.APPLICATION_ID
AND ECP.PRIOR_EVENT_CLASS_CODE = ECA.EVENT_CLASS_CODE
AND ECA.LANGUAGE = USERENV('LANG')
AND ECA.APPLICATION_ID = ETA.APPLICATION_ID
AND ECA.ENTITY_CODE = ETA.ENTITY_CODE
AND ETA.LANGUAGE = USERENV('LANG')