[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GMD_FORMULA_ANALYSIS_HDR |
|---|---|
| Object Type: | TABLE |
| Owner: | GMD |
| FND Design Data: |  GMD.GMD_FORMULA_ANALYSIS_HDR
|
| Subobject Name: | |
| Status: | VALID |
Formula Analysis Header table.
| Tablespace: |  APPS_TS_SEED |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| FORMULA_ID | NUMBER | Yes | Formula for which analysis has been run | |
| ORGN_CODE | VARCHAR2 | (4) | Organization under which analysis was run. | |
| EXPLOSION_RULE | NUMBER | Yes | Explosion rule used for intermediates during analysis.Valid options are: 0 = Use Production Formulas, 1 = Use Laboratory Formulas | |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column |
| CREATION_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
| LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
| ANALYSIS_QTY | NUMBER | This is the analysis qty. | ||
| ANALYSIS_UOM | VARCHAR2 | (4) | This is the analysis UOM. | |
| ORGANIZATION_ID | NUMBER | (15) | THIS IS THE INV ORGANIZATION ID | |
| LABORATORY_ID | NUMBER | (15) | This is the inv laboratory id | |
| ANALYSIS_HDR_UOM | VARCHAR2 | (3) | This is the Analysis UOM Column post-convergence |
Cut, paste (and edit) the following text to query this object:
SELECT FORMULA_ID
, ORGN_CODE
, EXPLOSION_RULE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ANALYSIS_QTY
, ANALYSIS_UOM
, ORGANIZATION_ID
, LABORATORY_ID
, ANALYSIS_HDR_UOM
FROM GMD.GMD_FORMULA_ANALYSIS_HDR;
GMD.GMD_FORMULA_ANALYSIS_HDR does not reference any database object
GMD.GMD_FORMULA_ANALYSIS_HDR is referenced by following:
GMD
GMD_FORMULA_ANALYSIS_HDR#
|
|
|
|