PAY_BALANCE_TYPES_VL

Details

• Schema: FUSION

• Object owner: PAY

• Object type: VIEW

Columns

Name

BALANCE_TYPE_ID LEGISLATIVE_DATA_GROUP_ID LEGISLATION_CODE ENTERPRISE_ID CURRENCY_CODE BASE_BALANCE_NAME BALANCE_NAME REPORTING_NAME BALANCE_UOM REMUNERATION_FLAG BALANCE_CATEGORY_ID BASE_BALANCE_TYPE_ID INPUT_VALUE_ID APPLICATION_ID DEDUCTION_TYPE_ID ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 COMMENTS LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATED_BY CREATION_DATE OBJECT_VERSION_NUMBER MODULE_ID ATTRIBUTE21 ATTRIBUTE22 ATTRIBUTE23 ATTRIBUTE24 ATTRIBUTE25 ATTRIBUTE26 ATTRIBUTE27 ATTRIBUTE28 ATTRIBUTE29 ATTRIBUTE30 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER11 ATTRIBUTE_NUMBER12 ATTRIBUTE_NUMBER13 ATTRIBUTE_NUMBER14 ATTRIBUTE_NUMBER15 ATTRIBUTE_NUMBER16 ATTRIBUTE_NUMBER17 ATTRIBUTE_NUMBER18 ATTRIBUTE_NUMBER19 ATTRIBUTE_NUMBER20 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_DATE6 ATTRIBUTE_DATE7 ATTRIBUTE_DATE8 ATTRIBUTE_DATE9 ATTRIBUTE_DATE10 ATTRIBUTE_DATE11 ATTRIBUTE_DATE12 ATTRIBUTE_DATE13 ATTRIBUTE_DATE14 ATTRIBUTE_DATE15 PBT_INFORMATION_CATEGORY PBT_INFORMATION_CHAR1 PBT_INFORMATION_CHAR2 PBT_INFORMATION_CHAR3 PBT_INFORMATION_CHAR4 PBT_INFORMATION_CHAR5 PBT_INFORMATION_CHAR6 PBT_INFORMATION_CHAR7 PBT_INFORMATION_CHAR8 PBT_INFORMATION_CHAR9 PBT_INFORMATION_CHAR10 PBT_INFORMATION_CHAR11 PBT_INFORMATION_CHAR12 PBT_INFORMATION_CHAR13 PBT_INFORMATION_CHAR14 PBT_INFORMATION_CHAR15 PBT_INFORMATION_CHAR16 PBT_INFORMATION_CHAR17 PBT_INFORMATION_CHAR18 PBT_INFORMATION_CHAR19 PBT_INFORMATION_CHAR20 PBT_INFORMATION_CHAR21 PBT_INFORMATION_CHAR22 PBT_INFORMATION_CHAR23 PBT_INFORMATION_CHAR24 PBT_INFORMATION_CHAR25 PBT_INFORMATION_CHAR26 PBT_INFORMATION_CHAR27 PBT_INFORMATION_CHAR28 PBT_INFORMATION_CHAR29 PBT_INFORMATION_CHAR30 PBT_INFORMATION_NUMBER1 PBT_INFORMATION_NUMBER2 PBT_INFORMATION_NUMBER3 PBT_INFORMATION_NUMBER4 PBT_INFORMATION_NUMBER5 PBT_INFORMATION_NUMBER6 PBT_INFORMATION_NUMBER7 PBT_INFORMATION_NUMBER8 PBT_INFORMATION_NUMBER9 PBT_INFORMATION_NUMBER10 PBT_INFORMATION_NUMBER11 PBT_INFORMATION_NUMBER12 PBT_INFORMATION_NUMBER13 PBT_INFORMATION_NUMBER14 PBT_INFORMATION_NUMBER15 PBT_INFORMATION_NUMBER16 PBT_INFORMATION_NUMBER17 PBT_INFORMATION_NUMBER18 PBT_INFORMATION_NUMBER19 PBT_INFORMATION_NUMBER20 PBT_INFORMATION_DATE1 PBT_INFORMATION_DATE2 PBT_INFORMATION_DATE3 PBT_INFORMATION_DATE4 PBT_INFORMATION_DATE5 PBT_INFORMATION_DATE6 PBT_INFORMATION_DATE7 PBT_INFORMATION_DATE8 PBT_INFORMATION_DATE9 PBT_INFORMATION_DATE10 PBT_INFORMATION_DATE11 PBT_INFORMATION_DATE12 PBT_INFORMATION_DATE13 PBT_INFORMATION_DATE14 PBT_INFORMATION_DATE15 DESCRIPTION

Query

SQL_Statement

SELECT pbt.BALANCE_TYPE_ID, pbt.LEGISLATIVE_DATA_GROUP_ID, pbt.LEGISLATION_CODE, pbt.ENTERPRISE_ID, pbt.CURRENCY_CODE, pbt.BASE_BALANCE_NAME, pbttl.BALANCE_NAME, pbttl.REPORTING_NAME, pbt.BALANCE_UOM, pbt.REMUNERATION_FLAG, pbt.BALANCE_CATEGORY_ID, pbt.BASE_BALANCE_TYPE_ID, pbt.INPUT_VALUE_ID, pbt.APPLICATION_ID, pbt.DEDUCTION_TYPE_ID, pbt.ATTRIBUTE_CATEGORY, pbt.ATTRIBUTE1, pbt.ATTRIBUTE2, pbt.ATTRIBUTE3, pbt.ATTRIBUTE4, pbt.ATTRIBUTE5, pbt.ATTRIBUTE6, pbt.ATTRIBUTE7, pbt.ATTRIBUTE8, pbt.ATTRIBUTE9, pbt.ATTRIBUTE10, pbt.ATTRIBUTE11, pbt.ATTRIBUTE12, pbt.ATTRIBUTE13, pbt.ATTRIBUTE14, pbt.ATTRIBUTE15, pbt.ATTRIBUTE16, pbt.ATTRIBUTE17, pbt.ATTRIBUTE18, pbt.ATTRIBUTE19, pbt.ATTRIBUTE20, pbt.COMMENTS, pbt.LAST_UPDATE_DATE, pbt.LAST_UPDATED_BY, pbt.LAST_UPDATE_LOGIN, pbt.CREATED_BY, pbt.CREATION_DATE, pbt.OBJECT_VERSION_NUMBER, pbt.MODULE_ID, pbt.ATTRIBUTE21, pbt.ATTRIBUTE22, pbt.ATTRIBUTE23, pbt.ATTRIBUTE24, pbt.ATTRIBUTE25, pbt.ATTRIBUTE26, pbt.ATTRIBUTE27, pbt.ATTRIBUTE28, pbt.ATTRIBUTE29, pbt.ATTRIBUTE30, pbt.ATTRIBUTE_NUMBER1, pbt.ATTRIBUTE_NUMBER2, pbt.ATTRIBUTE_NUMBER3, pbt.ATTRIBUTE_NUMBER4, pbt.ATTRIBUTE_NUMBER5, pbt.ATTRIBUTE_NUMBER6, pbt.ATTRIBUTE_NUMBER7, pbt.ATTRIBUTE_NUMBER8, pbt.ATTRIBUTE_NUMBER9, pbt.ATTRIBUTE_NUMBER10, pbt.ATTRIBUTE_NUMBER11, pbt.ATTRIBUTE_NUMBER12, pbt.ATTRIBUTE_NUMBER13, pbt.ATTRIBUTE_NUMBER14, pbt.ATTRIBUTE_NUMBER15, pbt.ATTRIBUTE_NUMBER16, pbt.ATTRIBUTE_NUMBER17, pbt.ATTRIBUTE_NUMBER18, pbt.ATTRIBUTE_NUMBER19, pbt.ATTRIBUTE_NUMBER20, pbt.ATTRIBUTE_DATE1, pbt.ATTRIBUTE_DATE2, pbt.ATTRIBUTE_DATE3, pbt.ATTRIBUTE_DATE4, pbt.ATTRIBUTE_DATE5, pbt.ATTRIBUTE_DATE6, pbt.ATTRIBUTE_DATE7, pbt.ATTRIBUTE_DATE8, pbt.ATTRIBUTE_DATE9, pbt.ATTRIBUTE_DATE10, pbt.ATTRIBUTE_DATE11, pbt.ATTRIBUTE_DATE12, pbt.ATTRIBUTE_DATE13, pbt.ATTRIBUTE_DATE14, pbt.ATTRIBUTE_DATE15, pbt.PBT_INFORMATION_CATEGORY, pbt.PBT_INFORMATION_CHAR1, pbt.PBT_INFORMATION_CHAR2, pbt.PBT_INFORMATION_CHAR3, pbt.PBT_INFORMATION_CHAR4, pbt.PBT_INFORMATION_CHAR5, pbt.PBT_INFORMATION_CHAR6, pbt.PBT_INFORMATION_CHAR7, pbt.PBT_INFORMATION_CHAR8, pbt.PBT_INFORMATION_CHAR9, pbt.PBT_INFORMATION_CHAR10, pbt.PBT_INFORMATION_CHAR11, pbt.PBT_INFORMATION_CHAR12, pbt.PBT_INFORMATION_CHAR13, pbt.PBT_INFORMATION_CHAR14, pbt.PBT_INFORMATION_CHAR15, pbt.PBT_INFORMATION_CHAR16, pbt.PBT_INFORMATION_CHAR17, pbt.PBT_INFORMATION_CHAR18, pbt.PBT_INFORMATION_CHAR19, pbt.PBT_INFORMATION_CHAR20, pbt.PBT_INFORMATION_CHAR21, pbt.PBT_INFORMATION_CHAR22, pbt.PBT_INFORMATION_CHAR23, pbt.PBT_INFORMATION_CHAR24, pbt.PBT_INFORMATION_CHAR25, pbt.PBT_INFORMATION_CHAR26, pbt.PBT_INFORMATION_CHAR27, pbt.PBT_INFORMATION_CHAR28, pbt.PBT_INFORMATION_CHAR29, pbt.PBT_INFORMATION_CHAR30, pbt.PBT_INFORMATION_NUMBER1, pbt.PBT_INFORMATION_NUMBER2, pbt.PBT_INFORMATION_NUMBER3, pbt.PBT_INFORMATION_NUMBER4, pbt.PBT_INFORMATION_NUMBER5, pbt.PBT_INFORMATION_NUMBER6, pbt.PBT_INFORMATION_NUMBER7, pbt.PBT_INFORMATION_NUMBER8, pbt.PBT_INFORMATION_NUMBER9, pbt.PBT_INFORMATION_NUMBER10, pbt.PBT_INFORMATION_NUMBER11, pbt.PBT_INFORMATION_NUMBER12, pbt.PBT_INFORMATION_NUMBER13, pbt.PBT_INFORMATION_NUMBER14, pbt.PBT_INFORMATION_NUMBER15, pbt.PBT_INFORMATION_NUMBER16, pbt.PBT_INFORMATION_NUMBER17, pbt.PBT_INFORMATION_NUMBER18, pbt.PBT_INFORMATION_NUMBER19, pbt.PBT_INFORMATION_NUMBER20, pbt.PBT_INFORMATION_DATE1, pbt.PBT_INFORMATION_DATE2, pbt.PBT_INFORMATION_DATE3, pbt.PBT_INFORMATION_DATE4, pbt.PBT_INFORMATION_DATE5, pbt.PBT_INFORMATION_DATE6, pbt.PBT_INFORMATION_DATE7, pbt.PBT_INFORMATION_DATE8, pbt.PBT_INFORMATION_DATE9, pbt.PBT_INFORMATION_DATE10, pbt.PBT_INFORMATION_DATE11, pbt.PBT_INFORMATION_DATE12, pbt.PBT_INFORMATION_DATE13, pbt.PBT_INFORMATION_DATE14, pbt.PBT_INFORMATION_DATE15, pbttl.DESCRIPTION FROM PAY_BALANCE_TYPES pbt, PAY_BALANCE_TYPES_TL pbttl WHERE pbttl.BALANCE_TYPE_ID = pbt.BALANCE_TYPE_ID AND pbttl.LANGUAGE = USERENV('LANG')