DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.IGSBV_PARTY_BALANCES

Object Details
Object Name: IGSBV_PARTY_BALANCES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGSBV_PARTY_BALANCES
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


In context of an account, gives balance amount for a party


[View Source]

Columns
Name Datatype Length Mandatory Comments
BALANCE_IDENTIFIER NUMBER (15) Yes Balance identifier, primary key for the table
PARTY_IDENTIFIER NUMBER (15) Yes Person for which balance is being calculated
BALANCE_DATE DATE
Yes Balance calculation date
STANDARD_BALANCE NUMBER

Balance Amount for Standard Balance
FEE_BALANCE NUMBER

Balance Amount for Fee Balance
HOLDS_BALANCE NUMBER

Balance Amount for Holds Balance
PARTY_NUMBER VARCHAR2 (30) Yes Party number
PARTY_NAME VARCHAR2 (360) Yes Party name
FEE_BALANCE_RULE_IDENTIFIER NUMBER (15)
Balance rule identifier for the Fee Balance that is used by Balance Process for deriving the balance amounts
HOLDS_BALANCE_RULE_IDENTIFIER NUMBER (15)
Balance rule identifier for the Holds Balance that is used by Balance Process for deriving the balance amounts
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BALANCE_IDENTIFIER
,      PARTY_IDENTIFIER
,      BALANCE_DATE
,      STANDARD_BALANCE
,      FEE_BALANCE
,      HOLDS_BALANCE
,      PARTY_NUMBER
,      PARTY_NAME
,      FEE_BALANCE_RULE_IDENTIFIER
,      HOLDS_BALANCE_RULE_IDENTIFIER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_PARTY_BALANCES;

Dependencies

[top of page]

APPS.IGSBV_PARTY_BALANCES references the following:

SchemaAPPS
SynonymHZ_PARTIES
SynonymIGS_FI_BALANCES

APPS.IGSBV_PARTY_BALANCES is not referenced by any database object