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.IGSFV_CAL_PRD_EVNT_TYP_CONFIGS

Object Details

Object Name:	IGSFV_CAL_PRD_EVNT_TYP_CONFIGS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGSFV_CAL_PRD_EVNT_TYP_CONFIGS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This entity contains the seeded system date types that are used for date type configurations.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SYSTEM_DATE_TYPE	VARCHAR2	(30)	Yes	Seeded system date type
_LA:OWNER_MODULE	CHAR	(62)		Owning module for the system date type
VALIDATION_PROCEDURE	VARCHAR2	(100)		Validation procedure for the system date type
ONE_PER_CAL_FLAG	VARCHAR2	(1)	Yes	Flag to indicate if multiple instances of the system date type can be created in a single calendar instance.
_LA:RESTRICTED_CAL_CATEGORY	CHAR	(53)		Restricted calendar category for the system date type
_LA:ALTERNATE_CAL_CATEGORY	CHAR	(53)		Alternate calendar category for the system date type
DATE_ALIAS	VARCHAR2	(10)		User assigned date alias value for the system date type
SYSTEM_DATE_TYPE_DESC	VARCHAR2	(80)	Yes	Short description of the system date type
DATE_ALIAS_DESCRIPTION	VARCHAR2	(60)	Yes	User assigned date alias value description for the system date type
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 SYSTEM_DATE_TYPE
,      _LA:OWNER_MODULE
,      VALIDATION_PROCEDURE
,      ONE_PER_CAL_FLAG
,      _LA:RESTRICTED_CAL_CATEGORY
,      _LA:ALTERNATE_CAL_CATEGORY
,      DATE_ALIAS
,      SYSTEM_DATE_TYPE_DESC
,      DATE_ALIAS_DESCRIPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_CAL_PRD_EVNT_TYP_CONFIGS;

Dependencies

[top of page]

APPS.IGSFV_CAL_PRD_EVNT_TYP_CONFIGS references the following:

APPS: IGS_CA_DA; IGS_CA_DA_CONFIGS

APPS.IGSFV_CAL_PRD_EVNT_TYP_CONFIGS is not referenced by any database object