VIEW: APPS.CM_CLDR_MST_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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