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 231: gmd_status_b gs

227: gmd_routings_b rhdr,
228: (SELECT DISTINCT gr.routing_id
229: FROM gmd_recipes_b gr,
230: gmd_recipe_validity_rules grv,
231: gmd_status_b gs
232: WHERE gr.recipe_id = grv.recipe_id
233: AND grv.validity_rule_status = gs.status_code
234: AND gs.status_type IN ('700','900')
235: AND grv.recipe_use IN ('0','1') /* B13598533 */

Line 309: ||' gmd_status_b gs, '

305: ||' gc.routingstep_id, gc.oprn_line_id, gc.recipe_id, '
306: ||' gc.activity_factor, '
307: ||' gc.resources, gc.resource_usage, gc.process_qty '
308: ||' FROM gmd_recipes grb, '
309: ||' gmd_status_b gs, '
310: ||' ( '
311: ||' SELECT '
312: ||' gor.recipe_id, '
313: ||' gor.organization_id, '

Line 431: ||' gmd_status_b gs, '

427: recipe_statement :=
428: ' SELECT grb.routing_id, grs.routingstep_id, grs.recipe_id, '
429: ||' grs.step_qty '
430: ||' FROM gmd_recipes grb, '
431: ||' gmd_status_b gs, '
432: ||' gmd_recipe_routing_steps grs '
433: ||' WHERE grb.recipe_id = grs.recipe_id '
434: ||' AND grb.delete_mark = 0 '
435: ||' AND grb.recipe_status = gs.status_code '

Line 502: ||' FROM gmd_status_b gs, '

498: ||' ORDER BY fmd.line_no DESC) frank, '--,fmd.last_update_date DESC) frank, '
499: --End of Bug 10398492
500: ||' eff.inventory_item_id , '
501: ||' fmd.scale_type ' -- Bug: 8736658 Added code to fetch scale type of product item
502: ||' FROM gmd_status_b gs, '
503: ||' mtl_parameters mp, '
504: ||' hr_organization_units hr, '
505: ||' fm_form_eff eff , '
506: ||' Fm_Matl_Dtl fmd '