APPS.GME_TRANSFORM_BATCH dependencies on GMD_RECIPE_VALIDITY_RULES

Line 267: FROM gme_batch_header b, gmd_recipe_validity_rules v

263: l_batch_prefix VARCHAR2(80);
264: l_fpo_prefix VARCHAR2(80);
265: CURSOR get_batches IS
266: SELECT batch_no, b.organization_id, batch_type, v.inventory_item_id
267: FROM gme_batch_header b, gmd_recipe_validity_rules v
268: WHERE b.recipe_validity_rule_id = v.recipe_validity_rule_id(+)
269: AND b.organization_id IS NOT NULL
270: AND DECODE(batch_type, 0, l_batch_prefix, l_fpo_prefix)||batch_no
271: NOT IN (SELECT wip_entity_name