DBA Data[Home] [Help]

APPS.GMD_SAMPLES_GRP dependencies on FM_MATL_DTL

Line 3662: FROM fm_matl_dtl md

3658: AND s.status_type <> '1000'
3659: AND r.delete_mark = 0
3660: AND exists
3661: (SELECT 1
3662: FROM fm_matl_dtl md
3663: WHERE md.formula_id = r.formula_id
3664: AND md.inventory_item_id = p_sample.inventory_item_id)
3665: ;
3666:

Line 3670: FROM fm_form_mst f, fm_matl_dtl md

3666:
3667:
3668: CURSOR c_formulaline_id IS
3669: SELECT 1
3670: FROM fm_form_mst f, fm_matl_dtl md
3671: WHERE f.formula_id = md.formula_id
3672: AND f.formula_id = nvl(p_sample.formula_id, f.formula_id)
3673: AND md.formulaline_id = p_sample.formulaline_id
3674: AND md.inventory_item_id = p_sample.inventory_item_id

Line 6161: FROM fm_matl_dtl fd,

6157: -- bug 4640143: added cursors for formulaline and batch line
6158: /* CURSOR Cur_formulaline IS
6159: SELECT fd.line_no,
6160: gem.meaning
6161: FROM fm_matl_dtl fd,
6162: gem_lookups gem
6163: WHERE fd.formula_id = P_formula_id
6164: AND fd.formulaline_id = P_formulaline_id
6165: AND fd.inventory_item_id = P_inventory_item_id