View: XLA_EVENT_CLASS_PREDECS_F_V

Product:	XLA - Subledger Accounting
Description:	View created to pick up columns from xla_event_class_predecs table and additonal columns to be shown on the form.
Implementation/DBA Data:	APPS.XLA_EVENT_CLASS_PREDECS_F_V

View Text

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')

Columns