APPS.GMD_ERES_UTILS dependencies on GEM_LOOKUPS

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 940: FROM gem_lookups

936: p_called_from_form IN VARCHAR2,
937: x_return_status OUT NOCOPY VARCHAR2) IS
938: CURSOR Cur_get_desc IS
939: SELECT meaning
940: FROM gem_lookups
941: WHERE lookup_type = 'GMD_SRCH_RPLCE_CRIT_TYPE'
942: AND lookup_code = 'FORMULA';
943:
944: CURSOR Cur_get_status_desc (pstatus VARCHAR2) IS

Line 1173: FROM gem_lookups

1169: p_called_from_form IN VARCHAR2,
1170: x_return_status OUT NOCOPY VARCHAR2) IS
1171: CURSOR Cur_get_desc IS
1172: SELECT meaning
1173: FROM gem_lookups
1174: WHERE lookup_type = 'GMD_SRCH_RPLCE_CRIT_TYPE'
1175: AND lookup_code = 'OPERATION';
1176:
1177: CURSOR Cur_get_status_desc (pstatus VARCHAR2) IS

Line 1364: FROM gem_lookups

1360: p_called_from_form IN VARCHAR2,
1361: x_return_status OUT NOCOPY VARCHAR2) IS
1362: CURSOR Cur_get_desc IS
1363: SELECT meaning
1364: FROM gem_lookups
1365: WHERE lookup_type = 'GMD_SRCH_RPLCE_CRIT_TYPE'
1366: AND lookup_code = 'ROUTING';
1367:
1368: CURSOR Cur_get_status_desc (pstatus VARCHAR2) IS

Line 1550: FROM gem_lookups

1546: p_called_from_form IN VARCHAR2,
1547: x_return_status OUT NOCOPY VARCHAR2) IS
1548: CURSOR Cur_get_desc IS
1549: SELECT meaning
1550: FROM gem_lookups
1551: WHERE lookup_type = 'GMD_SRCH_RPLCE_CRIT_TYPE'
1552: AND lookup_code = 'RECIPE';
1553:
1554: CURSOR Cur_get_status_desc (pstatus VARCHAR2) IS

Line 1862: FROM gem_lookups

1858:
1859: /* Get the recipe use lookup meaning */
1860: CURSOR Cur_get_lookup_meaning(vlookup_code NUMBER) IS
1861: SELECT meaning
1862: FROM gem_lookups
1863: WHERE lookup_type = 'GMD_FORMULA_USE'
1864: AND lookup_code = vlookup_code;
1865:
1866: l_replace_type_desc VARCHAR2(240);

Line 2266: FROM gem_lookups

2262: l_recipe_use_temp VARCHAR2(40);
2263:
2264: CURSOR Cur_recipe_use(V_lookup_code VARCHAR2) IS
2265: SELECT meaning
2266: FROM gem_lookups
2267: WHERE lookup_type = 'GMD_FORMULA_USE'
2268: and lookup_code = V_lookup_code;
2269:
2270: BEGIN

Line 2573: FROM GEM_LOOKUPS

2569: AND a.routing_status = b.status_code;
2570:
2571: CURSOR Cur_get_value (vLookup_code VARCHAR2) IS
2572: SELECT MEANING
2573: FROM GEM_LOOKUPS
2574: WHERE LOOKUP_TYPE = 'GME_YES'
2575: AND LOOKUP_CODE = vLookup_code;
2576:
2577: l_temp_id VARCHAR2(240);