[Home] [Help]
View: PAY_DEFINED_BALANCES_V
View Text
SELECT PDB.ROWID
, PDB.DEFINED_BALANCE_ID
, PDB.BUSINESS_GROUP_ID + 0
, PBD.LEGISLATION_CODE
, PDB.BALANCE_TYPE_ID
, PBD.BALANCE_DIMENSION_ID
, PBD.DIMENSION_NAME
, PBD.DATABASE_ITEM_SUFFIX
, PBD.ROUTE_ID
FROM PAY_BALANCE_DIMENSIONS PBD
, PAY_DEFINED_BALANCES PDB
WHERE PBD.BALANCE_DIMENSION_ID = PDB.BALANCE_DIMENSION_ID
Columns
Name |
ROW_ID |
DEFINED_BALANCE_ID |
BUSINESS_GROUP_ID |
LEGISLATION_CODE |
BALANCE_TYPE_ID |
BALANCE_DIMENSION_ID |
DIMENSION_NAME |
DATABASE_ITEM_SUFFIX |
ROUTE_ID |