DBA Data[Home] [Help] [Dependency Information]

VIEW: GMF.CM_RLUP_CTL#

Object Details
Object Name: CM_RLUP_CTL#
Object Type: VIEW
Owner: GMF
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
RANGE_TYPE NUMBER (1) Yes
FROM_RANGE VARCHAR2 (2000)
TO_RANGE VARCHAR2 (2000)
ROLLUP_ID NUMBER (10) Yes
CALENDAR_CODE VARCHAR2 (4)
PERIOD_CODE VARCHAR2 (4)
COST_MTHD_CODE VARCHAR2 (4)
RUNNING_IND NUMBER (5) Yes
SCHEDULED_ON VARCHAR2 (32) Yes
STARTED_BY NUMBER (15) Yes
STARTED_ON DATE

ENDED_ON DATE

FORMULA_CNT NUMBER (10)
PRODUCTS_CALC NUMBER (10)
BURDENS_CALC NUMBER (10)
COST_ROWS_CALC NUMBER (10)
ROLLUP_STAGE NUMBER (10)
ERRORS_FOUND NUMBER (10)
ERRORS_POSTED NUMBER (10)
ERRORS_LIMIT NUMBER (10) Yes
ABORT_IND NUMBER (5) Yes
ABORT_BY NUMBER (15)
ABORT_REASON VARCHAR2 (70)
SINGLE_LEVEL NUMBER (5) Yes
ITEM_ID NUMBER (10)
IN_USE NUMBER (10)
DELETE_MARK NUMBER (5) Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

DEFAULT_LANGUAGE VARCHAR2 (4)
FROM_ORGN_CODE VARCHAR2 (4)
TO_ORGN_CODE VARCHAR2 (4)
COST_TYPE_ID NUMBER (15)
FROM_ORGANIZATION_ID NUMBER (15)
INVENTORY_ITEM_ID NUMBER (15)
LEGAL_ENTITY_ID NUMBER (15)
PERIOD_ID NUMBER (15)
TO_ORGANIZATION_ID NUMBER (15)
MASTER_ORGANIZATION_ID NUMBER (15)
Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

GMF.CM_RLUP_CTL# references the following:

SchemaGMF
TableCM_RLUP_CTL
GMF.CM_RLUP_CTL# is referenced by following:

SchemaAPPS
SynonymCM_RLUP_CTL