DBA Data[Home] [Help]

APPS.INV_INVARCLI_XMLP_PKG dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 220: WMS_LICENSE_PLATE_NUMBERS

216: SELECT
217: LICENSE_PLATE_NUMBER
218: INTO M_OUTERMOST_LPN
219: FROM
220: WMS_LICENSE_PLATE_NUMBERS
221: WHERE LPN_ID = OUTERMOST_LPN_ID;
222: IF SQL%NOTFOUND THEN
223: M_OUTERMOST_LPN := 'ERROR';
224: END IF;

Line 241: WMS_LICENSE_PLATE_NUMBERS

237: SELECT
238: LICENSE_PLATE_NUMBER
239: INTO M_PARENT_LPN
240: FROM
241: WMS_LICENSE_PLATE_NUMBERS
242: WHERE LPN_ID = PARENT_LPN_ID;
243: IF SQL%NOTFOUND THEN
244: M_PARENT_LPN := 'ERROR';
245: END IF;