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 2535: FROM fm_matl_dtl

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