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

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

Line 1175: FROM gem_lookups

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

Line 1366: FROM gem_lookups

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

Line 1552: FROM gem_lookups

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

Line 1864: FROM gem_lookups

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

Line 2268: FROM gem_lookups

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

Line 2575: FROM GEM_LOOKUPS

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