DBA Data[Home] [Help]

APPS.INV_INVARPSL_XMLP_PKG dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 203: WMS_LICENSE_PLATE_NUMBERS

199: SELECT
200: LICENSE_PLATE_NUMBER
201: INTO M_OUTERMOST_LPN
202: FROM
203: WMS_LICENSE_PLATE_NUMBERS
204: WHERE LPN_ID = OUTERMOST_LPN_ID;
205: EXCEPTION
206: WHEN NO_DATA_FOUND THEN
207: M_OUTERMOST_LPN := 'ERROR';

Line 222: WMS_LICENSE_PLATE_NUMBERS

218: SELECT
219: LICENSE_PLATE_NUMBER
220: INTO M_PARENT_LPN
221: FROM
222: WMS_LICENSE_PLATE_NUMBERS
223: WHERE LPN_ID = PARENT_LPN_ID;
224: EXCEPTION
225: WHEN NO_DATA_FOUND THEN
226: M_PARENT_LPN := 'ERROR';