DBA Data[Home] [Help]

APPS.RCV_RETURN_SV dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 106: from WMS_LICENSE_PLATE_NUMBERS

102: AND ROWNUM<=1;
103:
104: cursor get_license_plate_number(p_license_plate_id in varchar2) is
105: select LICENSE_PLATE_NUMBER
106: from WMS_LICENSE_PLATE_NUMBERS
107: where LPN_ID = p_license_plate_id
108: AND ROWNUM<=1;
109:
110: x_create_shipment_flag VARCHAR2(1) := NVL(FND_PROFILE.VALUE('RCV_CREATE_SHIPMENT_FOR_RETURNS'),'N'); -- rtv project