DBA Data[Home] [Help]

APPS.INV_INVARORE_XMLP_PKG dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 102: WMS_LICENSE_PLATE_NUMBERS

98: SELECT
99: LICENSE_PLATE_NUMBER
100: INTO X_PARENT_LPN
101: FROM
102: WMS_LICENSE_PLATE_NUMBERS
103: WHERE LPN_ID = PARENT_LPN_ID;
104: EXCEPTION
105: WHEN NO_DATA_FOUND THEN
106: X_PARENT_LPN := 'ERROR';

Line 125: WMS_LICENSE_PLATE_NUMBERS

121: SELECT
122: LICENSE_PLATE_NUMBER
123: INTO X_OUTERMOST_LPN
124: FROM
125: WMS_LICENSE_PLATE_NUMBERS
126: WHERE LPN_ID = OUTERMOST_LPN_ID;
127: EXCEPTION
128: WHEN NO_DATA_FOUND THEN
129: X_OUTERMOST_LPN := 'ERROR';