PAY_BAL_EXCEPTIONS

Details

Schema: FUSION
Object owner: PAY
Object type: VIEW

Columns

Name
BAL_EXCEPTION_ID REPORT_DEFINITION_ID BASE_BAL_EXCEPTION_NAME ENTERPRISE_ID LEGISLATION_CODE VARIANCE_OPERATOR OUTPUT_FORMAT LEGISLATIVE_DATA_GROUP_ID CURRENCY_CODE DEFINED_BALANCE_ID VARIANCE_TYPE VARIANCE_VALUE COMPARISON_TYPE COMPARISON_VALUE LAST_UPDATED_BY CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER BAL_EXCEPTION_NAME SEVERITY_LEVEL FORMULA_ID TARGET_DEFINED_BALANCE_ID MODULE_ID BALANCE_GROUP_ID

Name

BAL_EXCEPTION_ID

REPORT_DEFINITION_ID

BASE_BAL_EXCEPTION_NAME

ENTERPRISE_ID

LEGISLATION_CODE

VARIANCE_OPERATOR

OUTPUT_FORMAT

LEGISLATIVE_DATA_GROUP_ID

CURRENCY_CODE

DEFINED_BALANCE_ID

VARIANCE_TYPE

VARIANCE_VALUE

COMPARISON_TYPE

COMPARISON_VALUE

LAST_UPDATED_BY

CREATED_BY

CREATION_DATE

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

BAL_EXCEPTION_NAME

SEVERITY_LEVEL

FORMULA_ID

TARGET_DEFINED_BALANCE_ID

MODULE_ID

BALANCE_GROUP_ID

Query

SQL_Statement
SELECT PBE.BAL_EXCEPTION_ID, PBE.REPORT_DEFINITION_ID, PBE.BASE_BAL_EXCEPTION_NAME BASE_BAL_EXCEPTION_NAME, PBE.ENTERPRISE_ID, PBE.LEGISLATION_CODE, PBE.VARIANCE_OPERATOR, PBE.OUTPUT_FORMAT, PBE.LEGISLATIVE_DATA_GROUP_ID, PBE.CURRENCY_CODE, PBE.DEFINED_BALANCE_ID, PBE.VARIANCE_TYPE, PBE.VARIANCE_VALUE, PBE.COMPARISON_TYPE, PBE.COMPARISON_VALUE, PBE.LAST_UPDATED_BY, PBE.CREATED_BY, PBE.CREATION_DATE, PBE.LAST_UPDATE_DATE, PBE.LAST_UPDATE_LOGIN, PBE.OBJECT_VERSION_NUMBER, PBETL.BAL_EXCEPTION_NAME AS BAL_EXCEPTION_NAME, PBE.SEVERITY_LEVEL, PBE.FORMULA_ID, PBE.TARGET_DEFINED_BALANCE_ID, PBE.MODULE_ID, PBE.BALANCE_GROUP_ID FROM PAY_BAL_EXCEPTIONS_B PBE, PAY_BAL_EXCEPTIONS_TL PBETL WHERE PBETL.BAL_EXCEPTION_ID = PBE.BAL_EXCEPTION_ID AND PBETL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

PBE.BAL_EXCEPTION_ID,

PBE.REPORT_DEFINITION_ID,

PBE.BASE_BAL_EXCEPTION_NAME BASE_BAL_EXCEPTION_NAME,

PBE.ENTERPRISE_ID,

PBE.LEGISLATION_CODE,

PBE.VARIANCE_OPERATOR,

PBE.OUTPUT_FORMAT,

PBE.LEGISLATIVE_DATA_GROUP_ID,

PBE.CURRENCY_CODE,

PBE.DEFINED_BALANCE_ID,

PBE.VARIANCE_TYPE,

PBE.VARIANCE_VALUE,

PBE.COMPARISON_TYPE,

PBE.COMPARISON_VALUE,

PBE.LAST_UPDATED_BY,

PBE.CREATED_BY,

PBE.CREATION_DATE,

PBE.LAST_UPDATE_DATE,

PBE.LAST_UPDATE_LOGIN,

PBE.OBJECT_VERSION_NUMBER,

PBETL.BAL_EXCEPTION_NAME AS BAL_EXCEPTION_NAME,

PBE.SEVERITY_LEVEL,

PBE.FORMULA_ID,

PBE.TARGET_DEFINED_BALANCE_ID,

PBE.MODULE_ID,

PBE.BALANCE_GROUP_ID

FROM

PAY_BAL_EXCEPTIONS_B PBE,

PAY_BAL_EXCEPTIONS_TL PBETL

WHERE

PBETL.BAL_EXCEPTION_ID = PBE.BAL_EXCEPTION_ID AND PBETL.LANGUAGE = USERENV('LANG')