DBA Data[Home] [Help]

APPS.GMPRELAP dependencies on GMD_RECIPE_VALIDITY_RULES

Line 821: gmd_recipe_validity_rules grv,

817: -- B5259453, FPO can use planning and production validity rules
818: CURSOR Cur_get_eff_id IS
819: SELECT gr.recipe_id, count(1)
820: FROM gmd_recipes_b gr,
821: gmd_recipe_validity_rules grv,
822: gmd_status_b gs
823: WHERE grv.validity_rule_status in ('700','900')
824: AND gr.recipe_id = grv.recipe_id
825: AND grv.validity_rule_status = gs.status_code

Line 966: gmd_recipe_validity_rules b

962: SELECT a.batch_no, a.batch_type, a.batch_status,
963: a.plan_start_date, a.plan_cmplt_date,
964: a.recipe_validity_rule_id, b.recipe_id
965: FROM gme_batch_header a,
966: gmd_recipe_validity_rules b
967: WHERE a.batch_id = p_batch_id
968: AND a.organization_id = p_organization_id
969: AND a.recipe_validity_rule_id = b.recipe_validity_rule_id
970: AND b.delete_mark = 0