VIEW: APPS.PAY_BALANCE_CATEGORIES_F_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID,B.balance_category_id , TL.user_category_name , B.effective_start_date , B.effective_end_date , B.legislation_code , B.business_group_id , B.save_run_balance_enabled , B.user_category_name , B.pbc_information_category , B.pbc_information1 , B.pbc_information2 , B.pbc_information3 , B.pbc_information4 , B.pbc_information5 , B.pbc_information6 , B.pbc_information7 , B.pbc_information8 , B.pbc_information9 , B.pbc_information10 , B.pbc_information11 , B.pbc_information12 , B.pbc_information13 , B.pbc_information14 , B.pbc_information15 , B.pbc_information16 , B.pbc_information17 , B.pbc_information18 , B.pbc_information19 , B.pbc_information20 , B.pbc_information21 , B.pbc_information22 , B.pbc_information23 , B.pbc_information24 , B.pbc_information25 , B.pbc_information26 , B.pbc_information27 , B.pbc_information28 , B.pbc_information29 , B.pbc_information30 , B.last_update_date , B.last_updated_by , B.last_update_login , B.created_by , B.creation_date , B.object_version_number FROM PAY_BALANCE_CATEGORIES_F B ,PAY_BALANCE_CATEGORIES_F_TL TL WHERE B.BALANCE_CATEGORY_ID = TL.BALANCE_CATEGORY_ID AND TL.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.BALANCE_CATEGORY_ID
, TL.USER_CATEGORY_NAME
, B.EFFECTIVE_START_DATE
, B.EFFECTIVE_END_DATE
, B.LEGISLATION_CODE
, B.BUSINESS_GROUP_ID
, B.SAVE_RUN_BALANCE_ENABLED
, B.USER_CATEGORY_NAME
, B.PBC_INFORMATION_CATEGORY
, B.PBC_INFORMATION1
, B.PBC_INFORMATION2
, B.PBC_INFORMATION3
, B.PBC_INFORMATION4
, B.PBC_INFORMATION5
, B.PBC_INFORMATION6
, B.PBC_INFORMATION7
, B.PBC_INFORMATION8
, B.PBC_INFORMATION9
, B.PBC_INFORMATION10
, B.PBC_INFORMATION11
, B.PBC_INFORMATION12
, B.PBC_INFORMATION13
, B.PBC_INFORMATION14
, B.PBC_INFORMATION15
, B.PBC_INFORMATION16
, B.PBC_INFORMATION17
, B.PBC_INFORMATION18
, B.PBC_INFORMATION19
, B.PBC_INFORMATION20
, B.PBC_INFORMATION21
, B.PBC_INFORMATION22
, B.PBC_INFORMATION23
, B.PBC_INFORMATION24
, B.PBC_INFORMATION25
, B.PBC_INFORMATION26
, B.PBC_INFORMATION27
, B.PBC_INFORMATION28
, B.PBC_INFORMATION29
, B.PBC_INFORMATION30
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.CREATED_BY
, B.CREATION_DATE
, B.OBJECT_VERSION_NUMBER
FROM PAY_BALANCE_CATEGORIES_F B
, PAY_BALANCE_CATEGORIES_F_TL TL
WHERE B.BALANCE_CATEGORY_ID = TL.BALANCE_CATEGORY_ID
AND TL.LANGUAGE = USERENV('LANG')