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.GMD_SAMPLES_GRP dependencies on FM_MATL_DTL

Line 3067: FROM fm_matl_dtl md

3063: AND s.status_type <> '1000'
3064: AND r.delete_mark = 0
3065: AND exists
3066: (SELECT 1
3067: FROM fm_matl_dtl md
3068: WHERE md.formula_id = r.formula_id
3069: AND md.inventory_item_id = p_sample.inventory_item_id)
3070: ;
3071:

Line 3075: FROM fm_form_mst f, fm_matl_dtl md

3071:
3072:
3073: CURSOR c_formulaline_id IS
3074: SELECT 1
3075: FROM fm_form_mst f, fm_matl_dtl md
3076: WHERE f.formula_id = md.formula_id
3077: AND f.formula_id = nvl(p_sample.formula_id, f.formula_id)
3078: AND md.formulaline_id = p_sample.formulaline_id
3079: AND md.inventory_item_id = p_sample.inventory_item_id

Line 5493: FROM fm_matl_dtl fd,

5489: -- bug 4640143: added cursors for formulaline and batch line
5490: /* CURSOR Cur_formulaline IS
5491: SELECT fd.line_no,
5492: gem.meaning
5493: FROM fm_matl_dtl fd,
5494: gem_lookups gem
5495: WHERE fd.formula_id = P_formula_id
5496: AND fd.formulaline_id = P_formulaline_id
5497: AND fd.inventory_item_id = P_inventory_item_id