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.

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

VIEW: APPS.IGCFV_CBC_BALANCES

Object Details

Object Name:	IGCFV_CBC_BALANCES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGC.IGCFV_CBC_BALANCES
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

IGCFV_CBC_BALANCES display balances that are the cumulative results of financial operations.

[View Source]

Columns

Name	Datatype	Length	Mandatory
ACTUAL_FLAG	VARCHAR2	(1)
_KF:GL_ACCOUNT	CHAR	(34)
AMOUNT_TYPE	VARCHAR2	(4)
PERIOD_YEAR	NUMBER
ENTERED_DR	NUMBER
ENTERED_CR	NUMBER
PERIOD_NAME	VARCHAR2	(15)
PERIOD_SET_NAME	VARCHAR2	(15)
QUARTER_NUMBER	NUMBER
PERIOD_NUMBER	NUMBER
STATUS	VARCHAR2	(1)
DETAIL_SUMMARY_CODE	VARCHAR2	(1)
PERIOD_TO_DATE_BALANCE	NUMBER
SETS_OF_BOOKS_NAME	VARCHAR2	(30)
SETS_OF_BOOKS_SHORT_NAME	VARCHAR2	(20)
BUDGET_NAME	VARCHAR2	(15)
ENCUMBRANCE_TYPE_NAME	VARCHAR2	(30)
CURRENCY_CODE	VARCHAR2	(15)
CODE_COMBINATION_ID	NUMBER	(15)	Yes
SET_OF_BOOKS_ID	NUMBER
ENCUMBRANCE_TYPE_ID	NUMBER	(15)
BUDGET_VERSION_ID	NUMBER

Query Text

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


SELECT ACTUAL_FLAG
,      _KF:GL_ACCOUNT
,      AMOUNT_TYPE
,      PERIOD_YEAR
,      ENTERED_DR
,      ENTERED_CR
,      PERIOD_NAME
,      PERIOD_SET_NAME
,      QUARTER_NUMBER
,      PERIOD_NUMBER
,      STATUS
,      DETAIL_SUMMARY_CODE
,      PERIOD_TO_DATE_BALANCE
,      SETS_OF_BOOKS_NAME
,      SETS_OF_BOOKS_SHORT_NAME
,      BUDGET_NAME
,      ENCUMBRANCE_TYPE_NAME
,      CURRENCY_CODE
,      CODE_COMBINATION_ID
,      SET_OF_BOOKS_ID
,      ENCUMBRANCE_TYPE_ID
,      BUDGET_VERSION_ID
FROM APPS.IGCFV_CBC_BALANCES;

Dependencies

[top of page]

APPS.IGCFV_CBC_BALANCES references the following:

APPS: GL_BUDGET_VERSIONS; GL_CODE_COMBINATIONS; GL_ENCUMBRANCE_TYPES; GL_SETS_OF_BOOKS; IGC_CBC_INQUIRY_PKG - show dependent code; IGC_CBC_JE_LINES_BAL_PTD_V

APPS.IGCFV_CBC_BALANCES is not referenced by any database object