[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 |