154: SELECT
155: MEANING
156: INTO L_TEMP
157: FROM
158: OE_LOOKUPS
159: WHERE LOOKUP_TYPE = 'OEXOEIOD ORDER BY'
160: AND SUBSTR(LOOKUP_CODE
161: ,1
162: ,1) = SUBSTR(UPPER(P_ORDER_BY)
426: SELECT
427: MEANING
428: INTO L_MEANING
429: FROM
430: OE_LOOKUPS
431: WHERE LOOKUP_TYPE = 'REPORT_ORDER_CATEGORY'
432: AND LOOKUP_CODE = P_ORDER_CATEGORY;
433: RETURN (L_MEANING);
434: EXCEPTION
446: SELECT
447: MEANING
448: INTO L_MEANING
449: FROM
450: OE_LOOKUPS
451: WHERE LOOKUP_TYPE = 'REPORT_LINE_DISPLAY'
452: AND LOOKUP_CODE = P_LINE_CATEGORY;
453: RETURN (L_MEANING);
454: EXCEPTION
1013: l_meaning VARCHAR2 (80);
1014: BEGIN
1015: SELECT MEANING
1016: INTO l_meaning
1017: FROM OE_LOOKUPS
1018: WHERE LOOKUP_TYPE = 'ITEM_DISPLAY_CODE'
1019: AND LOOKUP_CODE = substr(upper(p_print_description),1,1)
1020: ;
1021:
1031: l_meaning VARCHAR2 (80);
1032: BEGIN
1033: SELECT MEANING
1034: INTO l_meaning
1035: FROM OE_LOOKUPS
1036: WHERE LOOKUP_TYPE = 'ITEM_DISPLAY_CODE'
1037: AND LOOKUP_CODE = substr(upper(p_print_description),1,1)
1038: ;
1039: