DBA Data[Home] [Help]

APPS.INV_VIEW_MTL_TXN dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 346: FROM WMS_LICENSE_PLATE_NUMBERS

342: IF p_LPN_ID IS NOT NULL THEN
343: BEGIN
344: SELECT LICENSE_PLATE_NUMBER
345: INTO x_LPN
346: FROM WMS_LICENSE_PLATE_NUMBERS
347: WHERE LPN_ID = p_LPN_ID ;
348: EXCEPTION
349: WHEN OTHERS THEN
350: NULL;

Line 358: FROM WMS_LICENSE_PLATE_NUMBERS

354: IF p_TRANSFER_LPN_ID IS NOT NULL THEN
355: BEGIN
356: SELECT LICENSE_PLATE_NUMBER
357: INTO x_TRANSFER_LPN
358: FROM WMS_LICENSE_PLATE_NUMBERS
359: WHERE LPN_ID = p_TRANSFER_LPN_ID ;
360: EXCEPTION
361: WHEN OTHERS THEN
362: NULL;

Line 369: FROM WMS_LICENSE_PLATE_NUMBERS

365: IF p_CONTENT_LPN_ID IS NOT NULL THEN
366: BEGIN
367: SELECT LICENSE_PLATE_NUMBER
368: INTO x_CONTENT_LPN
369: FROM WMS_LICENSE_PLATE_NUMBERS
370: WHERE LPN_ID = p_CONTENT_LPN_ID ;
371: EXCEPTION
372: WHEN OTHERS THEN
373: NULL;