VIEW: APPS.FM_FORM_EFF_VW3_OLD

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, NVL(grv.end_date,To_date(fnd_profile.value_wnps('SY$EFF_MAX_DATE'),'YYYY/MM/DD HH24:MI:SS')) 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, grc.customer_id 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 FROM gmd_recipes_b gr, gmd_recipe_validity_rules grv, gmd_status_b gs, gmd_recipe_customers grc WHERE (grv.validity_rule_status = '700' OR grv.validity_rule_status = '900') AND gr.recipe_id = grv.recipe_id AND grv.validity_rule_status = gs.status_code AND gr.recipe_id = grc.recipe_id(+)

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
, NVL(GRV.END_DATE
, TO_DATE(FND_PROFILE.VALUE_WNPS('SY$EFF_MAX_DATE')
, 'YYYY/MM/DD HH24:MI:SS')) 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
, GRC.CUSTOMER_ID 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
FROM GMD_RECIPES_B GR
, GMD_RECIPE_VALIDITY_RULES GRV
, GMD_STATUS_B GS
, GMD_RECIPE_CUSTOMERS GRC
WHERE (GRV.VALIDITY_RULE_STATUS = '700' OR GRV.VALIDITY_RULE_STATUS = '900')
AND GR.RECIPE_ID = GRV.RECIPE_ID
AND GRV.VALIDITY_RULE_STATUS = GS.STATUS_CODE
AND GR.RECIPE_ID = GRC.RECIPE_ID(+)