APPS.GMD_RECIPE_FETCH_PUB dependencies on GMD_RECIPE_ORGN_ACTIVITIES

Line 1247: FROM gmd_recipe_orgn_activities ra, fm_rout_dtl d,

1243: ra.attribute17, ra.attribute18, ra.attribute19, ra.attribute20,
1244: ra.attribute21, ra.attribute22, ra.attribute23, ra.attribute24,
1245: ra.attribute25, ra.attribute26, ra.attribute27, ra.attribute28,
1246: ra.attribute29, ra.attribute30, 1 recipe_override
1247: FROM gmd_recipe_orgn_activities ra, fm_rout_dtl d,
1248: gmd_operations_vl o, gmd_operation_activities a , fm_actv_mst fm
1249: WHERE ra.recipe_id = p_recipe_id
1250: AND d.routingstep_id = ra.routingstep_id
1251: AND d.oprn_id = o.oprn_id

Line 1277: FROM gmd_recipe_orgn_activities

1273: AND o.oprn_id = d.oprn_id
1274: AND a.oprn_id = o.oprn_id
1275: AND a.activity = fm.activity
1276: AND a.oprn_line_id NOT IN (SELECT oprn_line_id
1277: FROM gmd_recipe_orgn_activities
1278: WHERE recipe_id = p_recipe_id
1279: AND (p_organization_id IS NULL or organization_id = p_organization_id))
1280: ORDER BY routing_step_no, oprnline_id;
1281: -- END BUG#2686887