DBA Data[Home] [Help]

APPS.ONT_OEXPRPRD_XMLP_PKG dependencies on OE_LOOKUPS

Line 159: OE_LOOKUPS

155: SELECT
156: MEANING
157: INTO L_MEANING
158: FROM
159: OE_LOOKUPS
160: WHERE LOOKUP_TYPE = 'ITEM_DISPLAY_CODE'
161: AND LOOKUP_CODE = SUBSTR(UPPER(NVL(P_PRINT_DESCRIPTION,'D'))
162: ,1
163: ,1);

Line 642: OE_LOOKUPS

638: SELECT
639: MEANING
640: INTO L_MEANING
641: FROM
642: OE_LOOKUPS
643: WHERE LOOKUP_TYPE = 'REPORT_ORDER_CATEGORY'
644: AND LOOKUP_CODE = P_ORDER_CATEGORY;
645: RETURN (L_MEANING);
646: EXCEPTION

Line 683: OE_LOOKUPS

679: SELECT
680: MEANING
681: INTO L_MEANING
682: FROM
683: OE_LOOKUPS
684: WHERE LOOKUP_TYPE = 'REPORT_LINE_DISPLAY'
685: AND LOOKUP_CODE = P_LINE_CATEGORY;
686: RETURN (L_MEANING);
687: EXCEPTION