SELECT /* REGULAR ATTRIBUTES */ cpp.PAC_PERIOD_ID /*PK*/ ,cpp.PERIOD_SET_NAME ,cpp.PERIOD_START_DATE ,cpp.PERIOD_END_DATE ,cpp.OPEN_FLAG ,cpp.PERIOD_YEAR ,cpp.PERIOD_NUM ,cpp.PERIOD_NAME ,cpp.PERIOD_CLOSE_DATE /* FOREIGN KEYS RESOLVED */ /* ID */ ,cpp.LEGAL_ENTITY ,cpp.COST_TYPE_ID /* WHO */ ,cpp.creation_date ,cpp.created_by ,cpp.last_update_date ,cpp.last_updated_by from CST_PAC_PERIODS cpp with read only
SELECT /* REGULAR ATTRIBUTES */ CPP.PAC_PERIOD_ID /*PK*/
, CPP.PERIOD_SET_NAME
, CPP.PERIOD_START_DATE
, CPP.PERIOD_END_DATE
, CPP.OPEN_FLAG
, CPP.PERIOD_YEAR
, CPP.PERIOD_NUM
, CPP.PERIOD_NAME
, CPP.PERIOD_CLOSE_DATE /* FOREIGN KEYS RESOLVED */ /* ID */
, CPP.LEGAL_ENTITY
, CPP.COST_TYPE_ID /* WHO */
, CPP.CREATION_DATE
, CPP.CREATED_BY
, CPP.LAST_UPDATE_DATE
, CPP.LAST_UPDATED_BY
FROM CST_PAC_PERIODS CPP WITH READ ONLY
|
|
|