eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMP_LEAD_TIME_CALCULATOR_PKG dependencies on GMD_STATUS_B

Line 227: gmd_status_b gs

223: gmd_routings_b rhdr,
224: (SELECT distinct gr.routing_id
225: FROM gmd_recipes_b gr,
226: gmd_recipe_validity_rules grv,
227: gmd_status_b gs
228: WHERE gr.recipe_id = grv.recipe_id
229: AND grv.validity_rule_status = gs.status_code
230: AND gs.status_type IN ('700','900')
231: AND gs.delete_mark = 0

Line 305: ||' gmd_status_b gs, '

301: ||' gc.routingstep_id, gc.oprn_line_id, gc.recipe_id, '
302: ||' gc.activity_factor, '
303: ||' gc.resources, gc.resource_usage, gc.process_qty '
304: ||' FROM gmd_recipes grb, '
305: ||' gmd_status_b gs, '
306: ||' ( '
307: ||' SELECT '
308: ||' gor.recipe_id, '
309: ||' gor.organization_id, '

Line 397: ||' gmd_status_b gs, '

393: recipe_statement :=
394: ' SELECT grb.routing_id, grs.routingstep_id, grs.recipe_id, '
395: ||' grs.step_qty '
396: ||' FROM gmd_recipes grb, '
397: ||' gmd_status_b gs, '
398: ||' gmd_recipe_routing_steps grs '
399: ||' WHERE grb.recipe_id = grs.recipe_id '
400: ||' AND grb.delete_mark = 0 '
401: ||' AND grb.recipe_status = gs.status_code '

Line 457: ||' FROM gmd_status_b gs,'

453: ||' DENSE_RANK () '
454: ||' OVER (PARTITION BY eff.inventory_item_id,NVL(eff.organization_id,mp.organization_id) '
455: ||' ORDER BY eff.preference,eff.last_update_date DESC) drank, '
456: ||' eff.inventory_item_id '
457: ||' FROM gmd_status_b gs,'
458: ||' mtl_parameters mp, '
459: ||' hr_organization_units hr, '
460: ||' fm_form_eff eff '
461: ||' WHERE NVL(eff.organization_id,mp.organization_id) = mp.organization_id '