DBA Data[Home] [Help]

APPS.WMS_WMSSCHS1_XMLP_PKG dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 252: WMS_LICENSE_PLATE_NUMBERS

248: SELECT
249: LICENSE_PLATE_NUMBER
250: INTO P_LICENSE_PLATE_NUMBER
251: FROM
252: WMS_LICENSE_PLATE_NUMBERS
253: WHERE LPN_ID = LPN_ID_1;
254: ELSE
255: P_LICENSE_PLATE_NUMBER := '';
256: END IF;

Line 267: WMS_LICENSE_PLATE_NUMBERS

263: SELECT
264: LICENSE_PLATE_NUMBER
265: INTO P_OUTERMOST_LPN
266: FROM
267: WMS_LICENSE_PLATE_NUMBERS
268: WHERE LPN_ID = (
269: SELECT
270: OUTERMOST_LPN_ID
271: FROM

Line 272: WMS_LICENSE_PLATE_NUMBERS

268: WHERE LPN_ID = (
269: SELECT
270: OUTERMOST_LPN_ID
271: FROM
272: WMS_LICENSE_PLATE_NUMBERS
273: WHERE LPN_ID = LPN_ID_1 );
274: ELSE
275: P_OUTERMOST_LPN := ' ';
276: END IF;