VIEW: APPS.FM_FORM_EFF_VW3

Source

View Text - Preformatted

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

View Text - HTML Formatted

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