View: IGSBV_PARTY_BALANCES

Product:	IGS - Student System
Description:	In context of an account, gives balance amount for a party
Implementation/DBA Data:	APPS.IGSBV_PARTY_BALANCES

View Text

SELECT BAL.BALANCE_ID
, BAL.PARTY_ID
, BAL.BALANCE_DATE
, BAL.STANDARD_BALANCE
, BAL.FEE_BALANCE
, BAL.HOLDS_BALANCE
, HZ.PARTY_NUMBER
, HZ.PARTY_NAME
, BAL.FEE_BALANCE_RULE_ID
, BAL.HOLDS_BALANCE_RULE_ID
, BAL.CREATED_BY
, BAL.CREATION_DATE
, BAL.LAST_UPDATED_BY
, BAL.LAST_UPDATE_DATE
FROM IGS_FI_BALANCES BAL
, HZ_PARTIES HZ
WHERE BAL.PARTY_ID = HZ.PARTY_ID WITH READ ONLY

Columns