DBA Data[Home] [Help]

APPS.WSH_WSHRDSDL_XMLP_PKG dependencies on WSH_LOOKUPS

Line 60: WSH_LOOKUPS

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

Line 92: WSH_LOOKUPS

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

Line 99: WSH_LOOKUPS

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

Line 106: WSH_LOOKUPS

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