SELECT A.CAL_PER_INT_TYPE_ID, A.CAL_PERIOD_ID, A.INTERVAL_TYPE_ID, A.INTERVAL_NUMBER, B.PERIOD_NAME, B.PERIOD_YEAR, B.START_DATE, B.END_DATE, A.CREATION_DATE, A.CREATED_BY, A.LAST_UPDATE_DATE, A.LAST_UPDATED_BY, A.LAST_UPDATE_LOGIN FROM CN_CAL_PER_INT_TYPES A, CN_PERIOD_STATUSES B WHERE A.CAL_PERIOD_ID = B.PERIOD_ID
SELECT A.CAL_PER_INT_TYPE_ID
, A.CAL_PERIOD_ID
, A.INTERVAL_TYPE_ID
, A.INTERVAL_NUMBER
, B.PERIOD_NAME
, B.PERIOD_YEAR
, B.START_DATE
, B.END_DATE
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN
FROM CN_CAL_PER_INT_TYPES A
, CN_PERIOD_STATUSES B
WHERE A.CAL_PERIOD_ID = B.PERIOD_ID
|
|
|