View: XLA_EVENT_CLASS_ATTRS_FVL

Product:	XLA - Subledger Accounting
Description:
Implementation/DBA Data:	APPS.XLA_EVENT_CLASS_ATTRS_FVL

View Text

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

Columns