[Home] [Help] [Dependency Information]
Object Name: | ABM_CALCULATIONS |
---|---|
Object Type: | TABLE |
Owner: | ABM |
Subobject Name: | |
Status: | VALID |
Identifies the lowest level element in a CALCULATION PROCEDURE. A Calculation STEP does not reference another CALCULATION PROCEDURE.
Dynamic, heavy reads, low volume.
There are a fixed number of calculations which can be performed within ABMI. Each CAL PROC ELEM STEP must identify which calculation type it will implement. This is done by identifying the name of the action block which implements the desired calculation. Each ELEMENTARY STEP produces one and only one result.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ABM_CALCULATIONS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
M25_MODEL_ID
M03_CALC_PROC_ELEM_STEP_ID_CTR |
Table | |
Foreign Table | Foreign Key Column | ABM_CALCULATIONS | ABM_CALC_TMPLTS | ABM_CALCULATIONS I94_CALC_TEMPLT_NAME | ABM_CALCULATIONS | ABM_MDLS | ABM_CALCULATIONS M25_MODEL_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
M25_MODEL_ID | VARCHAR2 | (15) | Yes | Model Id. User-defined relationship of master list components that describes a particular part of an organisation, such as a division, a plant, the corporation. |
M03_CALC_PROC_ELEM_STEP_ID_CTR | NUMBER | Yes | Calculation procedure step Id. | |
M03_CALC_PROC_ELEM_STEP_NAME | VARCHAR2 | (90) | Yes | Calculation procedure step name. |
DESCRIPTION_TEXT | VARCHAR2 | (750) | Calculation procedure 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. | ||
I94_CALC_TEMPLT_NAME | VARCHAR2 | (150) | Yes | Calculation Template Name |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT M25_MODEL_ID
, M03_CALC_PROC_ELEM_STEP_ID_CTR
, M03_CALC_PROC_ELEM_STEP_NAME
, DESCRIPTION_TEXT
, MAINT_USER_ID
, MAINT_EFFECT_CODE
, MAINT_TIMESTAMP
, I94_CALC_TEMPLT_NAME
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM ABM.ABM_CALCULATIONS;
ABM.ABM_CALCULATIONS does not reference any database object
ABM.ABM_CALCULATIONS is not referenced by any database object
|
|
|