VIEW: GMF.CM_RLUP_CTL#

Source

View Text - Preformatted

select RANGE_TYPE RANGE_TYPE, FROM_RANGE FROM_RANGE, TO_RANGE TO_RANGE, ROLLUP_ID ROLLUP_ID, CALENDAR_CODE CALENDAR_CODE, PERIOD_CODE PERIOD_CODE, COST_MTHD_CODE COST_MTHD_CODE, RUNNING_IND RUNNING_IND, SCHEDULED_ON SCHEDULED_ON, STARTED_BY STARTED_BY, STARTED_ON STARTED_ON, ENDED_ON ENDED_ON, FORMULA_CNT FORMULA_CNT, PRODUCTS_CALC PRODUCTS_CALC, BURDENS_CALC BURDENS_CALC, COST_ROWS_CALC COST_ROWS_CALC, ROLLUP_STAGE ROLLUP_STAGE, ERRORS_FOUND ERRORS_FOUND, ERRORS_POSTED ERRORS_POSTED, ERRORS_LIMIT ERRORS_LIMIT, ABORT_IND ABORT_IND, ABORT_BY ABORT_BY, ABORT_REASON ABORT_REASON, SINGLE_LEVEL SINGLE_LEVEL, ITEM_ID ITEM_ID, IN_USE IN_USE, DELETE_MARK DELETE_MARK, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, DEFAULT_LANGUAGE DEFAULT_LANGUAGE, FROM_ORGN_CODE FROM_ORGN_CODE, TO_ORGN_CODE TO_ORGN_CODE, COST_TYPE_ID COST_TYPE_ID, FROM_ORGANIZATION_ID FROM_ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, PERIOD_ID PERIOD_ID, TO_ORGANIZATION_ID TO_ORGANIZATION_ID, MASTER_ORGANIZATION_ID MASTER_ORGANIZATION_ID from "GMF"."CM_RLUP_CTL"

View Text - HTML Formatted

SELECT RANGE_TYPE RANGE_TYPE
, FROM_RANGE FROM_RANGE
, TO_RANGE TO_RANGE
, ROLLUP_ID ROLLUP_ID
, CALENDAR_CODE CALENDAR_CODE
, PERIOD_CODE PERIOD_CODE
, COST_MTHD_CODE COST_MTHD_CODE
, RUNNING_IND RUNNING_IND
, SCHEDULED_ON SCHEDULED_ON
, STARTED_BY STARTED_BY
, STARTED_ON STARTED_ON
, ENDED_ON ENDED_ON
, FORMULA_CNT FORMULA_CNT
, PRODUCTS_CALC PRODUCTS_CALC
, BURDENS_CALC BURDENS_CALC
, COST_ROWS_CALC COST_ROWS_CALC
, ROLLUP_STAGE ROLLUP_STAGE
, ERRORS_FOUND ERRORS_FOUND
, ERRORS_POSTED ERRORS_POSTED
, ERRORS_LIMIT ERRORS_LIMIT
, ABORT_IND ABORT_IND
, ABORT_BY ABORT_BY
, ABORT_REASON ABORT_REASON
, SINGLE_LEVEL SINGLE_LEVEL
, ITEM_ID ITEM_ID
, IN_USE IN_USE
, DELETE_MARK DELETE_MARK
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, DEFAULT_LANGUAGE DEFAULT_LANGUAGE
, FROM_ORGN_CODE FROM_ORGN_CODE
, TO_ORGN_CODE TO_ORGN_CODE
, COST_TYPE_ID COST_TYPE_ID
, FROM_ORGANIZATION_ID FROM_ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, PERIOD_ID PERIOD_ID
, TO_ORGANIZATION_ID TO_ORGANIZATION_ID
, MASTER_ORGANIZATION_ID MASTER_ORGANIZATION_ID
FROM "GMF"."CM_RLUP_CTL"