VIEW: APPS.PAY_DEFINED_BALANCES_V2

Source

View Text - Preformatted

SELECT DB.ROWID ROW_ID , DB.DEFINED_BALANCE_ID , DB.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID , DB.LEGISLATION_CODE , DB.BALANCE_TYPE_ID , DB.BALANCE_DIMENSION_ID , DB.FORCE_LATEST_BALANCE_FLAG , DB.LEGISLATION_SUBGROUP , DB.LAST_UPDATE_DATE , DB.LAST_UPDATED_BY , DB.LAST_UPDATE_LOGIN , DB.CREATED_BY , DB.CREATION_DATE , BD.DIMENSION_NAME , BD.DESCRIPTION DIMENSION_DESCRIPTION , BDT.DIMENSION_NAME TL_DIMENSION_NAME , BDT.DESCRIPTION TL_DIMENSION_DESCRIPTION , DB.GROSSUP_ALLOWED_FLAG FROM PAY_DEFINED_BALANCES DB, PAY_BALANCE_DIMENSIONS BD, PAY_BALANCE_DIMENSIONS_TL BDT WHERE BD.BALANCE_DIMENSION_ID = DB.BALANCE_DIMENSION_ID AND BDT.BALANCE_DIMENSION_ID = BD.BALANCE_DIMENSION_ID AND BDT.LANGUAGE = USERENV('lang')

View Text - HTML Formatted

SELECT DB.ROWID ROW_ID
, DB.DEFINED_BALANCE_ID
, DB.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, DB.LEGISLATION_CODE
, DB.BALANCE_TYPE_ID
, DB.BALANCE_DIMENSION_ID
, DB.FORCE_LATEST_BALANCE_FLAG
, DB.LEGISLATION_SUBGROUP
, DB.LAST_UPDATE_DATE
, DB.LAST_UPDATED_BY
, DB.LAST_UPDATE_LOGIN
, DB.CREATED_BY
, DB.CREATION_DATE
, BD.DIMENSION_NAME
, BD.DESCRIPTION DIMENSION_DESCRIPTION
, BDT.DIMENSION_NAME TL_DIMENSION_NAME
, BDT.DESCRIPTION TL_DIMENSION_DESCRIPTION
, DB.GROSSUP_ALLOWED_FLAG
FROM PAY_DEFINED_BALANCES DB
, PAY_BALANCE_DIMENSIONS BD
, PAY_BALANCE_DIMENSIONS_TL BDT
WHERE BD.BALANCE_DIMENSION_ID = DB.BALANCE_DIMENSION_ID
AND BDT.BALANCE_DIMENSION_ID = BD.BALANCE_DIMENSION_ID
AND BDT.LANGUAGE = USERENV('LANG')