DBA Data[Home] [Help]

APPS.INV_INVARCTA_XMLP_PKG dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 414: WMS_LICENSE_PLATE_NUMBERS

410: SELECT
411: LICENSE_PLATE_NUMBER
412: INTO X_OUTERMOST_LPN
413: FROM
414: WMS_LICENSE_PLATE_NUMBERS
415: WHERE LPN_ID = L_OUTERMOST_LPN_ID;--bug14252379,parameter name same with the column name causing the ambiguous reference
416: EXCEPTION
417: WHEN NO_DATA_FOUND THEN
418: X_OUTERMOST_LPN := 'ERROR';

Line 438: WMS_LICENSE_PLATE_NUMBERS

434: SELECT
435: LICENSE_PLATE_NUMBER
436: INTO X_PARENT_LPN
437: FROM
438: WMS_LICENSE_PLATE_NUMBERS
439: WHERE LPN_ID = L_PARENT_LPN_ID;--bug14252379,parameter name same with the column name causing the ambiguous reference
440: EXCEPTION
441: WHEN NO_DATA_FOUND THEN
442: X_PARENT_LPN := 'ERROR';