View: GMF_FORM_EFF_VW

Product:	GMF - Process Manufacturing Financials
Description:	Internal helper view for Standard Cost Rollup
Implementation/DBA Data:	APPS.GMF_FORM_EFF_VW

View Text

SELECT DISTINCT GR.RECIPE_ID
, GRV.RECIPE_VALIDITY_RULE_ID FMEFF_ID
, GRV.VALIDITY_RULE_STATUS
, GS.STATUS_TYPE
, DECODE(GRV.ORGN_CODE
, NULL
, GRV.LAB_TYPE
, GRV.ORGN_CODE) ORGN_CODE
, GRV.ITEM_ID
, GRV.RECIPE_USE FORMULA_USE
, GRV.END_DATE
, GRV.START_DATE
, GRV.INV_MIN_QTY
, GRV.INV_MAX_QTY
, GRV.MIN_QTY
, GRV.MAX_QTY
, GRV.STD_QTY
, GRV.ITEM_UM
, GRV.PREFERENCE
, GR.ROUTING_ID
, GR.FORMULA_ID
, 0 CUST_ID
, GRV.CREATION_DATE
, GRV.LAST_UPDATE_DATE
, GRV.CREATED_BY
, GRV.LAST_UPDATED_BY
, GRV.DELETE_MARK
, GRV.TEXT_CODE
, 0 TRANS_CNT
, GRV.LAST_UPDATE_LOGIN
, GRV.PLANNED_PROCESS_LOSS
, GRV.INVENTORY_ITEM_ID
, GRV.REVISION
, GRV.ORGANIZATION_ID
, GRV.DETAIL_UOM
FROM GMD_RECIPES_B GR
, GMD_RECIPE_VALIDITY_RULES GRV
, GMD_STATUS_B GS
WHERE GR.RECIPE_ID = GRV.RECIPE_ID
AND GRV.VALIDITY_RULE_STATUS = GS.STATUS_CODE
AND GS.STATUS_TYPE IN ('400'
, '700'
, '900')

Columns