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


TABLE: GMD.GMD_FORMULA_ANALYSIS_HDR

Object Details
Object Name: GMD_FORMULA_ANALYSIS_HDR
Object Type: TABLE
Owner: GMD
FND Design Data: TableGMD.GMD_FORMULA_ANALYSIS_HDR
Subobject Name:
Status: VALID


Formula Analysis Header table.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Columns
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
Query Text

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;

Dependencies

[top of page]

GMD.GMD_FORMULA_ANALYSIS_HDR does not reference any database object

GMD.GMD_FORMULA_ANALYSIS_HDR is referenced by following:

SchemaGMD
ViewGMD_FORMULA_ANALYSIS_HDR#