FND Design Data [Home] [Help]

View: FM_FORM_EFF_VW1

Product: GMD - Process Manufacturing Product Development
Description: Item Effectivity View
Implementation/DBA Data: ViewAPPS.FM_FORM_EFF_VW1
View Text

SELECT ORGN_CODE
, ITEM_ID
, END_DATE
, FMEFF_ID
, STD_QTY
, ITEM_UM
, FORMULA_ID
FROM FM_FORM_EFF EFF
WHERE FORMULA_USE = 2
AND DELETE_MARK = 0

Columns

Name
ORGN_CODE
ITEM_ID
END_DATE
FMEFF_ID
STD_QTY
ITEM_UM
FORMULA_ID