APPS.GME_TRANSFORM_BATCH dependencies on GMD_RECIPE_VALIDITY_RULES

Line 310: FROM gme_batch_header b, gmd_recipe_validity_rules v

306:
307: /*
308: CURSOR get_batches IS
309: SELECT batch_no, b.organization_id, batch_type, v.inventory_item_id
310: FROM gme_batch_header b, gmd_recipe_validity_rules v
311: WHERE b.recipe_validity_rule_id = v.recipe_validity_rule_id(+)
312: AND b.organization_id IS NOT NULL
313: AND DECODE(batch_type, 0, l_batch_prefix, l_fpo_prefix)||batch_no
314: NOT IN (SELECT wip_entity_name

Line 340: FROM gme_batch_header b, gmd_recipe_validity_rules v

336:
337: -- Let's get all batches minus the ones already in wip entities.
338: CURSOR get_batches IS
339: SELECT batch_no, b.organization_id, batch_type, v.inventory_item_id
340: FROM gme_batch_header b, gmd_recipe_validity_rules v
341: WHERE b.recipe_validity_rule_id = v.recipe_validity_rule_id(+)
342: AND b.organization_id IS NOT NULL
343: MINUS
344: SELECT batch_no, b.organization_id, batch_type, v.inventory_item_id

Line 345: FROM gme_batch_header b, gmd_recipe_validity_rules v,

341: WHERE b.recipe_validity_rule_id = v.recipe_validity_rule_id(+)
342: AND b.organization_id IS NOT NULL
343: MINUS
344: SELECT batch_no, b.organization_id, batch_type, v.inventory_item_id
345: FROM gme_batch_header b, gmd_recipe_validity_rules v,
346: (SELECT wip_entity_name, organization_id, entity_type
347: FROM wip_entities
348: WHERE wip_entity_id > l_min_wip_entity_id
349: AND entity_type IN (9, 10)) w