DBA Data[Home] [Help]

APPS.ONT_OEXOEIOD_XMLP_PKG dependencies on OE_LOOKUPS

Line 158: OE_LOOKUPS

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)

Line 430: OE_LOOKUPS

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

Line 450: OE_LOOKUPS

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

Line 1017: FROM OE_LOOKUPS

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:

Line 1035: FROM OE_LOOKUPS

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: