[Home] [Help] [Dependency Information]
Object Name: | FM_IBOM_HDR# |
---|---|
Object Type: | VIEW |
Owner: | GMD |
Subobject Name: | |
Status: | VALID |
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) |
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#;
|
|
|