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

VIEW: APPS.IGCBV_CC_ENCUMBRANCE_CONTROLS

Object Details
Object Name: IGCBV_CC_ENCUMBRANCE_CONTROLS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGC.IGCBV_CC_ENCUMBRANCE_CONTROLS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


IGCBV_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)
PROVISIONAL_ENCMBRANCE_TYPE_ID NUMBER (15)
CONFIRMED_ENCUMBRANCE_TYPE_ID NUMBER (15)
ORGANIZATION_NAME VARCHAR2 (240) Yes
BUDGET_TYPE VARCHAR2 (2) Yes
ORGANIZATION_ID NUMBER (15) 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
,      PROVISIONAL_ENCMBRANCE_TYPE_ID
,      CONFIRMED_ENCUMBRANCE_TYPE_ID
,      ORGANIZATION_NAME
,      BUDGET_TYPE
,      ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM APPS.IGCBV_CC_ENCUMBRANCE_CONTROLS;

Dependencies

[top of page]

APPS.IGCBV_CC_ENCUMBRANCE_CONTROLS references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymIGC_CC_ENCMBRNC_CTRLS

APPS.IGCBV_CC_ENCUMBRANCE_CONTROLS is not referenced by any database object