[Home] [Help] [Dependency Information]
Object Name: | FM_FORM_EFF_VW3_OLD |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GMD.FM_FORM_EFF_VW3_OLD |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
MultiLingual view (a language resolved view of the data.)
Item Effectivity view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RECIPE_ID | NUMBER | (15) | Yes | Recipe ID |
FMEFF_ID | NUMBER | (15) | Yes | Formula effectivity ID |
VALIDITY_RULE_STATUS | VARCHAR2 | (30) | Yes | Validity rules status |
STATUS_TYPE | VARCHAR2 | (30) | Yes | |
ORGN_CODE | VARCHAR2 | (4) | ||
ITEM_ID | NUMBER | (15) | ||
FORMULA_USE | VARCHAR2 | (30) | Yes | |
END_DATE | DATE | |||
START_DATE | DATE | Yes | ||
INV_MIN_QTY | NUMBER | Yes | ||
INV_MAX_QTY | NUMBER | Yes | ||
MIN_QTY | NUMBER | Yes | ||
MAX_QTY | NUMBER | Yes | ||
STD_QTY | NUMBER | Yes | ||
ITEM_UM | VARCHAR2 | (4) | ||
PREFERENCE | NUMBER | (15) | Yes | |
ROUTING_ID | NUMBER | (15) | ||
FORMULA_ID | NUMBER | (10) | Yes | |
CUST_ID | NUMBER | (15) | ||
CREATION_DATE | DATE | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
DELETE_MARK | NUMBER | (5) | Yes | |
TEXT_CODE | NUMBER | (10) | ||
TRANS_CNT | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT RECIPE_ID
, FMEFF_ID
, VALIDITY_RULE_STATUS
, STATUS_TYPE
, ORGN_CODE
, ITEM_ID
, FORMULA_USE
, END_DATE
, START_DATE
, INV_MIN_QTY
, INV_MAX_QTY
, MIN_QTY
, MAX_QTY
, STD_QTY
, ITEM_UM
, PREFERENCE
, ROUTING_ID
, FORMULA_ID
, CUST_ID
, CREATION_DATE
, LAST_UPDATE_DATE
, CREATED_BY
, LAST_UPDATED_BY
, DELETE_MARK
, TEXT_CODE
, TRANS_CNT
, LAST_UPDATE_LOGIN
FROM APPS.FM_FORM_EFF_VW3_OLD;
APPS.FM_FORM_EFF_VW3_OLD is not referenced by any database object
|
|
|