DBA Data[Home] [Help]

APPS.ONT_OEXOEUBK_XMLP_PKG dependencies on OE_LOOKUPS

Line 209: FROM OE_LOOKUPS

205: l_meaning VARCHAR2 (80);
206: BEGIN
207: SELECT MEANING
208: INTO l_meaning
209: FROM OE_LOOKUPS
210: WHERE LOOKUP_TYPE = 'ITEM_DISPLAY_CODE'
211: AND LOOKUP_CODE = substr(upper(p_print_description),1,1)
212: ;
213:

Line 277: OE_LOOKUPS

273: SELECT
274: MEANING
275: INTO LP_ORDER_BY_MEAN
276: FROM
277: OE_LOOKUPS
278: WHERE LOOKUP_CODE = UPPER(P_ORDER_BY)
279: AND LOOKUP_TYPE = 'OEXOEUBK ORDER BY';
280: ELSE
281: LP_ORDER_BY := 'order by 1,2,4';

Line 361: OE_LOOKUPS

357: SELECT
358: MEANING
359: INTO L_MEANING
360: FROM
361: OE_LOOKUPS
362: WHERE LOOKUP_TYPE = 'REPORT_ORDER_CATEGORY'
363: AND LOOKUP_CODE = P_ORDER_CATEGORY;
364: RETURN (L_MEANING);
365: EXCEPTION

Line 381: OE_LOOKUPS

377: SELECT
378: MEANING
379: INTO L_MEANING
380: FROM
381: OE_LOOKUPS
382: WHERE LOOKUP_TYPE = 'REPORT_LINE_DISPLAY'
383: AND LOOKUP_CODE = P_LINE_CATEGORY;
384: RETURN (L_MEANING);
385: EXCEPTION