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

Object Details

Object Name:	CM_CLDR_MST_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMF.CM_CLDR_MST_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

View on period statuses & calendars

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERIOD_ID	NUMBER	(15)	Yes	period identifier
PERIOD_CODE	VARCHAR2	(10)	Yes	period code
PERIOD_DESC	VARCHAR2	(40)	Yes	period description
CALENDAR_CODE	VARCHAR2	(10)	Yes	calendar code
CALENDAR_DESC	VARCHAR2	(40)	Yes	calendar description
LEGAL_ENTITY_ID	NUMBER	(15)	Yes	legal entity identifier
COST_TYPE_ID	NUMBER	(15)	Yes	cost type identifier
PERIOD_STATUS	VARCHAR2	(1)	Yes	period status
START_DATE	DATE		Yes	start date
END_DATE	DATE		Yes	end date
DELETE_MARK	NUMBER	(5)	Yes	delete mark

Query Text

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


SELECT PERIOD_ID
,      PERIOD_CODE
,      PERIOD_DESC
,      CALENDAR_CODE
,      CALENDAR_DESC
,      LEGAL_ENTITY_ID
,      COST_TYPE_ID
,      PERIOD_STATUS
,      START_DATE
,      END_DATE
,      DELETE_MARK
FROM APPS.CM_CLDR_MST_V;

Dependencies

[top of page]

APPS.CM_CLDR_MST_V references the following:

APPS: CM_CLDR_DTL; CM_CLDR_HDR; GMF_PERIOD_STATUSES

APPS.CM_CLDR_MST_V is referenced by following:

APPS: GMF_CMCOMMON - show dependent code; GMF_COPY_PERCENTAGE_BURDEN - show dependent code; GMF_COPY_RSRC_COST - show dependent code