[Home] [Help] [Dependency Information]
Object Name: | ABM_CALC_TMPLTS |
---|---|
Object Type: | TABLE |
Owner: | ABM |
Subobject Name: | |
Status: | VALID |
There are a fixed number of calculations defined to the ACTIVA II system. Each one of these has a template which defines its input parameters and output results.
Static, light reads.
Each calculation is implemented by an action block. Maintenance against one of these action blocks could make it impossible to recreate previous results. This is not acceptable if the books have been closed using those old results. This means that each time one of these action blocks has to be changed, a new copy has to be created, and the CALCULATION PROCEDURES that were linked to the old template have to be transferred to the new template.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ABM_CALC_TMPLTS_PK | NORMAL | UNIQUE | APPS_TS_SEED | I94_CALC_TEMPLT_NAME |
Table | |
Foreign Table | Foreign Key Column | ABM_CALC_TMPLTS | ABM_LAUNCHPAD_METADATA | ABM_CALC_TMPLTS CHILD_NODE | ABM_CALCS_LOG | ABM_CALC_TMPLTS | ABM_CALCS_LOG I94_CALC_TEMPLT_NAME | ABM_CALCULATIONS | ABM_CALC_TMPLTS | ABM_CALCULATIONS I94_CALC_TEMPLT_NAME |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
I94_CALC_TEMPLT_NAME | VARCHAR2 | (150) | Yes | Calculation Template Name |
EXECUTION_MODE_CODE | VARCHAR2 | (3) | Yes | Calculation Template Execution Mode |
DESCRIPTION_TEXT | VARCHAR2 | (750) | Calculation Template Description | |
MAINT_USER_ID | VARCHAR2 | (11) | Legacy column. No longer used in ABM 11i. | |
MAINT_EFFECT_CODE | VARCHAR2 | (1) | Legacy column. No longer used in ABM 11i. | |
MAINT_TIMESTAMP | DATE | Legacy column. No longer used in ABM 11i. | ||
MAIN_PROCEDURE | VARCHAR2 | (240) | This column holds stored procedure name corresponding to each calculation. | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
CHILD_NODE | VARCHAR2 | (100) | Calculation Template Child Node | |
TEMPLT_LOOKUP_CODE | VARCHAR2 | (50) | Calculation Template Lookup Code |
Cut, paste (and edit) the following text to query this object:
SELECT I94_CALC_TEMPLT_NAME
, EXECUTION_MODE_CODE
, DESCRIPTION_TEXT
, MAINT_USER_ID
, MAINT_EFFECT_CODE
, MAINT_TIMESTAMP
, MAIN_PROCEDURE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CHILD_NODE
, TEMPLT_LOOKUP_CODE
FROM ABM.ABM_CALC_TMPLTS;
ABM.ABM_CALC_TMPLTS does not reference any database object
ABM.ABM_CALC_TMPLTS is not referenced by any database object
|
|
|