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 74: OE_LOOKUPS

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

Line 129: OE_LOOKUPS

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

Line 149: OE_LOOKUPS

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

Line 169: OE_LOOKUPS

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

Line 449: OE_LOOKUPS

445: SELECT
446: MEANING
447: INTO L_MEANING
448: FROM
449: OE_LOOKUPS
450: WHERE LOOKUP_TYPE = 'REPORT_ORDER_CATEGORY'
451: AND LOOKUP_CODE = P_ORDER_CATEGORY;
452: RETURN (L_MEANING);
453: EXCEPTION

Line 901: OE_LOOKUPS

897: SELECT
898: MEANING
899: INTO L_MEANING
900: FROM
901: OE_LOOKUPS
902: WHERE LOOKUP_TYPE = 'REPORT_LINE_DISPLAY'
903: AND LOOKUP_CODE = P_LINE_CATEGORY;
904: RETURN (L_MEANING);
905: EXCEPTION

Line 921: OE_LOOKUPS

917: SELECT
918: MEANING
919: INTO L_MEANING
920: FROM
921: OE_LOOKUPS
922: WHERE LOOKUP_TYPE = 'ITEM_DISPLAY_CODE'
923: AND LOOKUP_CODE = P_PRINT_DESCRIPTION;
924: RETURN (L_MEANING);
925: EXCEPTION

Line 1834: OE_LOOKUPS

1830: SELECT
1831: MEANING
1832: INTO PA_END_DISPLAY
1833: FROM
1834: OE_LOOKUPS
1835: WHERE LOOKUP_TYPE = 'YES_NO'
1836: AND LOOKUP_CODE = P_END_CUST;
1837: RETURN (PA_END_DISPLAY);
1838: EXCEPTION