DBA Data[Home] [Help]

APPS.ONT_OEXOEORS_XMLP_PKG dependencies on OE_LOOKUPS

Line 218: FROM OE_LOOKUPS

214: l_meaning VARCHAR2 (80);
215: BEGIN
216: SELECT MEANING
217: INTO l_meaning
218: FROM OE_LOOKUPS
219: WHERE LOOKUP_TYPE = 'ITEM_DISPLAY_CODE'
220: AND LOOKUP_CODE = substr(upper(p_print_description),1,1)
221: ;
222:

Line 233: FROM OE_LOOKUPS

229: l_meaning VARCHAR2 (80);
230: BEGIN
231: SELECT MEANING
232: INTO l_meaning
233: FROM OE_LOOKUPS
234: WHERE LOOKUP_TYPE = 'YES_NO'
235: AND LOOKUP_CODE = substr(upper(p_open_returns_only),1,1)
236: ;
237:

Line 248: from oe_lookups

244: l_fc_display VARCHAR2(80);
245: BEGIN
246: select meaning
247: into l_fc_display
248: from oe_lookups
249: where lookup_type='YES_NO'
250: and lookup_code = p_use_functional_currency
251: ;
252:

Line 433: OE_LOOKUPS

429: SELECT
430: MEANING
431: INTO L_SORT_BY
432: FROM
433: OE_LOOKUPS
434: WHERE LOOKUP_CODE = P_ORDER_BY
435: AND LOOKUP_TYPE = 'OEXOEORS SORT BY';
436: RETURN (L_SORT_BY);
437: EXCEPTION