56: SELECT
57: MEANING
58: INTO REPORT_ITEM_DISPLAY
59: FROM
60: WSH_LOOKUPS
61: WHERE LOOKUP_TYPE = 'ITEM_DISPLAY'
62: AND LOOKUP_CODE = P_ITEM_DISPLAY;
63: END IF;
64: IF (P_SHIP_DATE_LOW IS NOT NULL) THEN
88: SELECT
89: MEANING
90: INTO REPORT_SORT_BY_1
91: FROM
92: WSH_LOOKUPS
93: WHERE LOOKUP_TYPE = 'WSH_ORDER_BY'
94: AND LOOKUP_CODE = P_ORDER_BY_1;
95: SELECT
96: MEANING
95: SELECT
96: MEANING
97: INTO REPORT_SORT_BY_2
98: FROM
99: WSH_LOOKUPS
100: WHERE LOOKUP_TYPE = 'WSH_ORDER_BY'
101: AND LOOKUP_CODE = P_ORDER_BY_2;
102: SELECT
103: MEANING
102: SELECT
103: MEANING
104: INTO REPORT_SORT_BY_3
105: FROM
106: WSH_LOOKUPS
107: WHERE LOOKUP_TYPE = 'WSH_ORDER_BY'
108: AND LOOKUP_CODE = P_ORDER_BY_3;
109: EXCEPTION
110: WHEN OTHERS THEN