DBA Data[Home] [Help]

APPS.INV_INVARORE_XMLP_PKG dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 105: WMS_LICENSE_PLATE_NUMBERS

101: SELECT
102: LICENSE_PLATE_NUMBER
103: INTO X_PARENT_LPN
104: FROM
105: WMS_LICENSE_PLATE_NUMBERS
106: WHERE LPN_ID = L_PARENT_LPN_ID;--bug14252379,parameter name same with the column name causing the ambiguous reference
107: EXCEPTION
108: WHEN NO_DATA_FOUND THEN
109: X_PARENT_LPN := 'ERROR';

Line 131: WMS_LICENSE_PLATE_NUMBERS

127: SELECT
128: LICENSE_PLATE_NUMBER
129: INTO X_OUTERMOST_LPN
130: FROM
131: WMS_LICENSE_PLATE_NUMBERS
132: WHERE LPN_ID = L_OUTERMOST_LPN_ID;--bug14252379,parameter name same with the column name causing the ambiguous reference
133: EXCEPTION
134: WHEN NO_DATA_FOUND THEN
135: X_OUTERMOST_LPN := 'ERROR';