APPS.GMP_LEAD_TIME_CALCULATOR_PKG dependencies on GMD_OPERATION_RESOURCES

Line 225: gmd_operation_resources ores,

221: -1 o_resource_usage,
222: -1 o_activity_factor
223: FROM gmd_operations opr,
224: gmd_operation_activities act,
225: gmd_operation_resources ores,
226: fm_rout_dtl rdtl,
227: gmd_routings_b rhdr,
228: (SELECT DISTINCT gr.routing_id
229: FROM gmd_recipes_b gr,

Line 376: ||' , gmd_operation_resources ores ' /* Bug 13877108 */

372: ||' AND goa.oprn_line_id = gor.oprn_line_id '
373: ||' AND goa.routingstep_id = gor.routingstep_id ) '
374: ||' ) gc '
375: ||' , gmd_operation_activities act ' /* Bug 13877108 */
376: ||' , gmd_operation_resources ores ' /* Bug 13877108 */
377: ||' WHERE grb.recipe_id = gc.recipe_id '
378: ||' AND grb.delete_mark = 0 '
379: ||' AND grb.recipe_status = gs.status_code '
380: ||' AND gs.status_type IN (' ||'''700'''|| ',' ||'''900'''|| ') '