eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGSFV_PARTY_BALANCES

Product:	IGS - Student System
Description:	In context of an account, gives balance amount for a party
Implementation/DBA Data:	APPS.IGSFV_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
, RUL1.BALANCE_NAME
, RUL1.VERSION_NUMBER
, BAL.HOLDS_BALANCE_RULE_ID
, RUL2.BALANCE_NAME
, RUL2.VERSION_NUMBER
, BAL.CREATED_BY
, BAL.CREATION_DATE
, BAL.LAST_UPDATED_BY
, BAL.LAST_UPDATE_DATE
FROM IGS_FI_BALANCES BAL
, HZ_PARTIES HZ
, IGS_FI_BALANCE_RULES RUL1
, IGS_FI_BALANCE_RULES RUL2
WHERE BAL.PARTY_ID = HZ.PARTY_ID
AND BAL.FEE_BALANCE_RULE_ID = RUL1.BALANCE_RULE_ID (+)
AND BAL.HOLDS_BALANCE_RULE_ID = RUL2.BALANCE_RULE_ID (+) WITH READ ONLY

Columns

Name
BALANCE_IDENTIFIER
PARTY_IDENTIFIER
BALANCE_DATE
STANDARD_BALANCE
FEE_BALANCE
HOLDS_BALANCE
PARTY_NUMBER
PARTY_NAME
FEE_BALANCE_RULE_IDENTIFIER
FEE_BALANCE_NAME
FEE_BALANCE_VERSION_NUMBER
HOLDS_BALANCE_RULE_IDENTIFIER
HOLDS_BALANCE_NAME
HOLDS_BALANCE_VERSION_NUMBER
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE