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

VIEW: GMD.FM_IBOM_HDR#

Object Details
Object Name: FM_IBOM_HDR#
Object Type: VIEW
Owner: GMD
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
TOP_FORMULA_ID NUMBER (10) Yes
ITEM_ID NUMBER (10)
SCALE_PERCENT NUMBER
Yes
FORMULA_USE NUMBER (1) Yes
EFFECTIVITY_DATE DATE
Yes
FORMULA_QTY NUMBER
Yes
REPORT_QTY NUMBER
Yes
REPORT_UOM VARCHAR2 (4) Yes
USE_INACTIVE_FLAG NUMBER (1)
MAX_EXPLODE_LEVELS NUMBER (2) Yes
EXPLODED_BY NUMBER (15) Yes
EXPLODED_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATED_BY NUMBER (15) Yes
STATUS_CODE VARCHAR2 (30)
ORGN_CODE VARCHAR2 (4)
VALIDITY_ORGANIZATION_TYPE NUMBER (1)
ORGANIZATION_ID NUMBER (15)
INVENTORY_ITEM_ID NUMBER (15)
DISPLAY_QTY NUMBER (5)
EXPLODE_IND NUMBER (5)
SCALE_ALLOWED NUMBER (5)
Query Text

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


SELECT TOP_FORMULA_ID
,      ITEM_ID
,      SCALE_PERCENT
,      FORMULA_USE
,      EFFECTIVITY_DATE
,      FORMULA_QTY
,      REPORT_QTY
,      REPORT_UOM
,      USE_INACTIVE_FLAG
,      MAX_EXPLODE_LEVELS
,      EXPLODED_BY
,      EXPLODED_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      STATUS_CODE
,      ORGN_CODE
,      VALIDITY_ORGANIZATION_TYPE
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      DISPLAY_QTY
,      EXPLODE_IND
,      SCALE_ALLOWED
FROM GMD.FM_IBOM_HDR#;

Dependencies

[top of page]

GMD.FM_IBOM_HDR# references the following:

SchemaGMD
TableFM_IBOM_HDR
GMD.FM_IBOM_HDR# is referenced by following:

SchemaAPPS
SynonymFM_IBOM_HDR