APPS.ONT_OEXOECOD_XMLP_PKG dependencies on OE_LOOKUPS

Line 12: OE_LOOKUPS

8: SELECT
9: MEANING
10: INTO ORDER_BY_DISPLAY
11: FROM
12: OE_LOOKUPS
13: WHERE LOOKUP_TYPE = 'OEXOAPOA ORDER BY'
14: AND LOOKUP_CODE = P_ORDER_BY;
15: RETURN (ORDER_BY_DISPLAY);
16: END;

Line 76: OE_LOOKUPS

72: SELECT
73: MEANING
74: INTO OPEN_ORDERS
75: FROM
76: OE_LOOKUPS
77: WHERE LOOKUP_TYPE = 'YES_NO'
78: AND LOOKUP_CODE = P_OPEN_ORDERS;
79: RETURN (OPEN_ORDERS);
80: EXCEPTION

Line 131: OE_LOOKUPS

127: SELECT
128: MEANING
129: INTO SC_DISPLAY
130: FROM
131: OE_LOOKUPS
132: WHERE LOOKUP_TYPE = 'YES_NO'
133: AND LOOKUP_CODE = P_SALES_CREDITS;
134: RETURN (SC_DISPLAY);
135: EXCEPTION

Line 151: OE_LOOKUPS

147: SELECT
148: MEANING
149: INTO PA_DISPLAY
150: FROM
151: OE_LOOKUPS
152: WHERE LOOKUP_TYPE = 'YES_NO'
153: AND LOOKUP_CODE = P_ADJUSTMENTS;
154: RETURN (PA_DISPLAY);
155: EXCEPTION

Line 171: OE_LOOKUPS

167: SELECT
168: MEANING
169: INTO FC_DISPLAY
170: FROM
171: OE_LOOKUPS
172: WHERE LOOKUP_TYPE = 'YES_NO'
173: AND LOOKUP_CODE = P_FUNCTIONAL_CURRENCY;
174: RETURN (FC_DISPLAY);
175: EXCEPTION

Line 453: OE_LOOKUPS

449: SELECT
450: MEANING
451: INTO L_MEANING
452: FROM
453: OE_LOOKUPS
454: WHERE LOOKUP_TYPE = 'REPORT_ORDER_CATEGORY'
455: AND LOOKUP_CODE = P_ORDER_CATEGORY;
456: RETURN (L_MEANING);
457: EXCEPTION

Line 905: OE_LOOKUPS

901: SELECT
902: MEANING
903: INTO L_MEANING
904: FROM
905: OE_LOOKUPS
906: WHERE LOOKUP_TYPE = 'REPORT_LINE_DISPLAY'
907: AND LOOKUP_CODE = P_LINE_CATEGORY;
908: RETURN (L_MEANING);
909: EXCEPTION

Line 925: OE_LOOKUPS

921: SELECT
922: MEANING
923: INTO L_MEANING
924: FROM
925: OE_LOOKUPS
926: WHERE LOOKUP_TYPE = 'ITEM_DISPLAY_CODE'
927: AND LOOKUP_CODE = P_PRINT_DESCRIPTION;
928: RETURN (L_MEANING);
929: EXCEPTION

Line 1838: OE_LOOKUPS

1834: SELECT
1835: MEANING
1836: INTO PA_END_DISPLAY
1837: FROM
1838: OE_LOOKUPS
1839: WHERE LOOKUP_TYPE = 'YES_NO'
1840: AND LOOKUP_CODE = P_END_CUST;
1841: RETURN (PA_END_DISPLAY);
1842: EXCEPTION