APPS.GMD_RECIPE_FETCH_PUB dependencies on GMD_RECIPE_ORGN_ACTIVITIES

Line 1292: FROM gmd_recipe_orgn_activities ra, fm_rout_dtl d,

1288: ra.attribute17, ra.attribute18, ra.attribute19, ra.attribute20,
1289: ra.attribute21, ra.attribute22, ra.attribute23, ra.attribute24,
1290: ra.attribute25, ra.attribute26, ra.attribute27, ra.attribute28,
1291: ra.attribute29, ra.attribute30, 1 recipe_override
1292: FROM gmd_recipe_orgn_activities ra, fm_rout_dtl d,
1293: gmd_operations_vl o, gmd_operation_activities a , fm_actv_mst fm
1294: WHERE ra.recipe_id = p_recipe_id
1295: AND d.routingstep_id = ra.routingstep_id
1296: AND d.oprn_id = o.oprn_id

Line 1322: FROM gmd_recipe_orgn_activities

1318: AND o.oprn_id = d.oprn_id
1319: AND a.oprn_id = o.oprn_id
1320: AND a.activity = fm.activity
1321: AND a.oprn_line_id NOT IN (SELECT oprn_line_id
1322: FROM gmd_recipe_orgn_activities
1323: WHERE recipe_id = p_recipe_id
1324: AND (p_organization_id IS NULL or organization_id = p_organization_id))
1325: --Added the order by for the bug 12613037.
1326: ORDER BY routing_step_no,offset_interval, activity, oprnline_id;