DBA Data[Home] [Help]

APPS.GMD_ERES_UTILS dependencies on FM_MATL_DTL

Line 264: FROM gem_lookups g, fm_matl_dtl d

260: --===================================================================== */
261: PROCEDURE get_line_type_desc (P_formulaline_id IN NUMBER, P_line_type_desc OUT NOCOPY VARCHAR2) IS
262: CURSOR Cur_get_meaning IS
263: SELECT meaning
264: FROM gem_lookups g, fm_matl_dtl d
265: WHERE formulaline_id = P_formulaline_id
266: AND lookup_type = 'LINE_TYPE'
267: AND lookup_code = d.line_type;
268: BEGIN

Line 2537: FROM fm_matl_dtl

2533: --===================================================================== */
2534: PROCEDURE get_formula_line_no(P_formulaline_id IN NUMBER,P_formulaline_no OUT NOCOPY NUMBER) IS
2535: CURSOR Cur_get_lineno IS
2536: SELECT LINE_NO
2537: FROM fm_matl_dtl
2538: WHERE formulaline_id = P_formulaline_id;
2539: BEGIN
2540: OPEN Cur_get_lineno;
2541: FETCH Cur_get_lineno INTO P_formulaline_no;