VIEW: APPS.XLA_EVENT_CLASS_ATTRS_FVL

Source

View Text - Preformatted

SELECT actg.rowid row_id ,actg.application_id application_id ,x.application_name application_name ,actg.entity_code entity_code ,actg.event_class_code event_class_code ,actg.je_category_name je_category_name ,tl.name event_class_name ,etl.name entity_name ,j.user_je_category_name user_je_category_name ,actg.event_class_group_code event_class_group_code ,gtl.name event_class_group_name ,actg.reporting_view_name reporting_view_name ,actg.allow_actuals_flag allow_actuals_flag ,actg.allow_budgets_flag allow_budgets_flag ,actg.allow_encumbrance_flag allow_encumbrance_flag ,actg.calculate_acctd_amts_flag calculate_acctd_amts_flag ,actg.calculate_g_l_amts_flag calculate_g_l_amts_flag ,actg.creation_date creation_date ,actg.created_by created_by ,actg.last_update_date last_update_date ,actg.last_updated_by last_updated_by ,actg.last_update_login last_update_login FROM xla_event_classes_tl tl ,xla_event_class_attrs actg ,xla_entity_types_tl etl ,xla_event_class_grps_tl gtl ,gl_je_categories j ,xla_applications_xvl x WHERE actg.application_id = tl.application_id AND actg.entity_code = tl.entity_code AND actg.event_class_code = tl.event_class_code AND tl.language = USERENV('LANG') AND actg.application_id = etl.application_id AND actg.entity_code = etl.entity_code AND etl.language = USERENV('LANG') AND actg.application_id = gtl.application_id AND actg.event_class_group_code = gtl.event_class_group_code AND gtl.language = USERENV('LANG') AND j.je_category_name = actg.je_category_name AND actg.application_id = x.application_id AND actg.entity_code NOT IN ('MANUAL', 'THIRD_PARTY_MERGE')

View Text - HTML Formatted

SELECT ACTG.ROWID ROW_ID
, ACTG.APPLICATION_ID APPLICATION_ID
, X.APPLICATION_NAME APPLICATION_NAME
, ACTG.ENTITY_CODE ENTITY_CODE
, ACTG.EVENT_CLASS_CODE EVENT_CLASS_CODE
, ACTG.JE_CATEGORY_NAME JE_CATEGORY_NAME
, TL.NAME EVENT_CLASS_NAME
, ETL.NAME ENTITY_NAME
, J.USER_JE_CATEGORY_NAME USER_JE_CATEGORY_NAME
, ACTG.EVENT_CLASS_GROUP_CODE EVENT_CLASS_GROUP_CODE
, GTL.NAME EVENT_CLASS_GROUP_NAME
, ACTG.REPORTING_VIEW_NAME REPORTING_VIEW_NAME
, ACTG.ALLOW_ACTUALS_FLAG ALLOW_ACTUALS_FLAG
, ACTG.ALLOW_BUDGETS_FLAG ALLOW_BUDGETS_FLAG
, ACTG.ALLOW_ENCUMBRANCE_FLAG ALLOW_ENCUMBRANCE_FLAG
, ACTG.CALCULATE_ACCTD_AMTS_FLAG CALCULATE_ACCTD_AMTS_FLAG
, ACTG.CALCULATE_G_L_AMTS_FLAG CALCULATE_G_L_AMTS_FLAG
, ACTG.CREATION_DATE CREATION_DATE
, ACTG.CREATED_BY CREATED_BY
, ACTG.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ACTG.LAST_UPDATED_BY LAST_UPDATED_BY
, ACTG.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM XLA_EVENT_CLASSES_TL TL
, XLA_EVENT_CLASS_ATTRS ACTG
, XLA_ENTITY_TYPES_TL ETL
, XLA_EVENT_CLASS_GRPS_TL GTL
, GL_JE_CATEGORIES J
, XLA_APPLICATIONS_XVL X
WHERE ACTG.APPLICATION_ID = TL.APPLICATION_ID
AND ACTG.ENTITY_CODE = TL.ENTITY_CODE
AND ACTG.EVENT_CLASS_CODE = TL.EVENT_CLASS_CODE
AND TL.LANGUAGE = USERENV('LANG')
AND ACTG.APPLICATION_ID = ETL.APPLICATION_ID
AND ACTG.ENTITY_CODE = ETL.ENTITY_CODE
AND ETL.LANGUAGE = USERENV('LANG')
AND ACTG.APPLICATION_ID = GTL.APPLICATION_ID
AND ACTG.EVENT_CLASS_GROUP_CODE = GTL.EVENT_CLASS_GROUP_CODE
AND GTL.LANGUAGE = USERENV('LANG')
AND J.JE_CATEGORY_NAME = ACTG.JE_CATEGORY_NAME
AND ACTG.APPLICATION_ID = X.APPLICATION_ID
AND ACTG.ENTITY_CODE NOT IN ('MANUAL'
, 'THIRD_PARTY_MERGE')