DBA Data[Home] [Help]

APPS.INV_INVARCPA_XMLP_PKG dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 108: WMS_LICENSE_PLATE_NUMBERS

104: SELECT
105: LICENSE_PLATE_NUMBER
106: INTO M_OUTERMOST_LPN
107: FROM
108: WMS_LICENSE_PLATE_NUMBERS
109: WHERE LPN_ID = L_OUTERMOST_LPN_ID;--bug14252379,parameter name same with the column name causing the ambiguous reference
110: EXCEPTION
111: WHEN NO_DATA_FOUND THEN
112: M_OUTERMOST_LPN := 'ERROR';

Line 134: WMS_LICENSE_PLATE_NUMBERS

130: SELECT
131: LICENSE_PLATE_NUMBER
132: INTO M_PARENT_LPN
133: FROM
134: WMS_LICENSE_PLATE_NUMBERS
135: WHERE LPN_ID = L_PARENT_LPN_ID;--bug14252379,parameter name same with the column name causing the ambiguous reference
136: EXCEPTION
137: WHEN NO_DATA_FOUND THEN
138: M_PARENT_LPN := 'ERROR';