[Home] [Help]
View: FM_FORM_EFF_VW1
| Product: | GMD - Process Manufacturing Product Development |
| Description: | Item Effectivity View |
| Implementation/DBA Data: |
APPS.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 |