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.

[Home] [Help]

View: CM_CLDR_MST_V

Product:	GMF - Process Manufacturing Financials
Description:	View on period statuses & calendars
Implementation/DBA Data:	APPS.CM_CLDR_MST_V

View Text

SELECT A.PERIOD_ID
, A.PERIOD_CODE
, B.PERIOD_DESC
, A.CALENDAR_CODE
, C.CALENDAR_DESC
, A.LEGAL_ENTITY_ID
, A.COST_TYPE_ID
, A.PERIOD_STATUS
, A.START_DATE
, A.END_DATE
, B.DELETE_MARK
FROM GMF_PERIOD_STATUSES A
, CM_CLDR_DTL B
, CM_CLDR_HDR C
WHERE A.PERIOD_CODE = B.PERIOD_CODE
AND A.CALENDAR_CODE = C.CALENDAR_CODE
AND A.CALENDAR_CODE = B.CALENDAR_CODE

Columns

Name
PERIOD_ID
PERIOD_CODE
PERIOD_DESC
CALENDAR_CODE
CALENDAR_DESC
LEGAL_ENTITY_ID
COST_TYPE_ID
PERIOD_STATUS
START_DATE
END_DATE
DELETE_MARK