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

VIEW: APPS.IGSBV_HOLD_TYPE_DFLT_EFFECTS

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

View Type

A Business Intelligence System view


Describes the default effects that are applied to the associated hold type.


[View Source]

Columns
Name Datatype Length Mandatory Comments
HOLD_TYPE VARCHAR2 (10) Yes Code of an institution-defined hold type incorporating one or more system hold effect types.
SYSTEM_HOLD_EFFECT_TYPE VARCHAR2 (10) Yes System-defined hold effect used in the creation of institution-defined hold types.
NOTES VARCHAR2 (2000)
Text facility for entering additional information comments or details about the context institution-defined hold type.
HOLD_TYPE_DESCRIPTION VARCHAR2 (60) Yes Description of an institution-defined hold type incorporating one or more system hold effect types.
_LA:SYS_HOLD_EFFECT_TYP_DESC CHAR (71)
Description of system-defined hold effect used in the creation of institution-defined hold types.
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 HOLD_TYPE
,      SYSTEM_HOLD_EFFECT_TYPE
,      NOTES
,      HOLD_TYPE_DESCRIPTION
,      _LA:SYS_HOLD_EFFECT_TYP_DESC
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_HOLD_TYPE_DFLT_EFFECTS;

Dependencies

[top of page]

APPS.IGSBV_HOLD_TYPE_DFLT_EFFECTS references the following:

SchemaAPPS
SynonymIGS_FI_ENCMB_TYPE_ALL
SynonymIGS_FI_ENC_DFLT_EFT

APPS.IGSBV_HOLD_TYPE_DFLT_EFFECTS is not referenced by any database object