VIEW: APPS.PAY_DEFINED_BALANCES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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