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_CC_ENCUMBRANCE_CONTROLS

Object Details

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

View Type

A Business Intelligence System view

IGCFV_CC_ENCUMBRANCE_CONTROLS display the association between the operating unit, budget type, contract commitment state and general ledger encumbrance type. This determines the type of encumbrances that can occur for the combination of the listed types, and whether or not the given combination is enabled.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
_LA:PROV_ENCMBR_ENABLED_FLAG	CHAR	(59)
_LA:CONF_ENCMBR_ENABLED_FLAG	CHAR	(59)
ENCUMBRANCE_TYPE_NAME	VARCHAR2	(30)
ORGANIZATION_NAME	VARCHAR2	(240)	Yes
PROVISIONAL_ENCUMBRNCE_TYPE_ID	NUMBER	(15)
CONFIRMED_ENCUMBRNCE_TYPE_ID	NUMBER	(15)
ORGANIZATION_ID	NUMBER	(15)	Yes
BUDGET_TYPE	VARCHAR2	(2)	Yes
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).

Query Text

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


SELECT _LA:PROV_ENCMBR_ENABLED_FLAG
,      _LA:CONF_ENCMBR_ENABLED_FLAG
,      ENCUMBRANCE_TYPE_NAME
,      ORGANIZATION_NAME
,      PROVISIONAL_ENCUMBRNCE_TYPE_ID
,      CONFIRMED_ENCUMBRNCE_TYPE_ID
,      ORGANIZATION_ID
,      BUDGET_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM APPS.IGCFV_CC_ENCUMBRANCE_CONTROLS;

Dependencies

[top of page]

APPS.IGCFV_CC_ENCUMBRANCE_CONTROLS references the following:

APPS: GL_ENCUMBRANCE_TYPES; HR_ALL_ORGANIZATION_UNITS; IGC_CC_ENCMBRNC_CTRLS

APPS.IGCFV_CC_ENCUMBRANCE_CONTROLS is not referenced by any database object